Going to a particular record.

[Henley12]

I have a Work Order form which has an advanced search button. When this button is clicked, it opens another form with search options. Depending on the options chosen, it lists the records via a subform on the search form. By double-clicking a chosen Work Order number on the subform, how can I close the form and make the double-clicked work order the selected record on the Work Order form?

 

[ajetrumpet]

something like this:

on dbl_click (of subform field of your choice)

  docmd.openform "work orders form", acnormal, , _
    "[common field from both forms] = forms![search form name]![common field from both forms]"
      docmd.close acform, "search form name"

 

[gls]

Any chance of sharing your search form.