to follow

Is this if you only find one result?

Hi Ewa
I often use a double click event on the key field to open the selected form

HTH
John

When I do the search, it is on a specific customer, there is only one customer with that search criteria.
Would like to make a combo box and be able to double click on the customer and open the customer's form there. Med thinks it is perhaps too advanced.

On Double Click

Hi Ewa

Here is an example of double click
You don't need a combo box.

Private Sub ProjectID_DblClick(Cancel As Integer)
      DoCmd.OpenForm "ResourcesF", , , "ProjectId=" & ProjectID
End Sub

I am opening the form named ResourcesF where the ProjectID on the form and the projectID in the table are the same. (in other words - the record you are on.

HTH
John