Select And Display Data From Another Form

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

Guest

I have a form that is set to continuous. I'd like to double click on one of
the part numbers being displayed and have another form open up and have that
newly opened form display the details for the originally clicked on part
number.

I've set a macro to open the form, which works fine.

What I'm need help on is getting the opening form to display the part number
that was clicked on.

Help!
 
Nanette,

In the macro, in the Where Condition argument of the openForm action,
you can put like this...
[Part Number]=[Forms]![YourContinuousForm]![Part Number]
 
Nanette,

Do you mean it actually opens at the correct record on the second form,
but the correct PartNumber is not shown? Or do you mean it is opening,
but at a record whose PartNumber is 0?
 
Back
Top