open form, go to specified record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to double click on a specific record on a list (form), open a
new form, and go to that record either with a filter or query. I am more
familiar with macros than modules, but I don't know how to store the selected
record and move that into a query or filter.
 
Ddmarchus,

Presumably the records in the second form are identified by a unique
field? And presumably this same field is represented on the form you
are double-clicking on? So, refer to this field in the Where Condition
argument of the OpenForm action in your macro. It might be something
like this...
[ClientID]=[Forms]![FirstForm]![ClinetID]
 
Back
Top