Help with vb code for a simple form

[si_the_geek]

To find all of the records you may be able to use a Filter (I'm not quite sure how, as I don't use it myself), or you could simply re-open the recordset with a Where clause that contains your condition, eg:

Me.Recordset.Close
Me.Recordset.Open "SELECT * FROM tablename WHERE [EXTERNAL_REF] = '" & Me![Combo68] & "'"