Open a form on click to edit data from a Multiple Item Form

[NDClark]

I have a macro set to open another form (Edit Form) to edit data found on a
Multiple Item Form. The problem is the (Edit Form) always opens to the very
first record. I would like the form to open the record I click on. Would
someone give me some suggestions as to what I am doing wrong?

Please Help!!!
Thanks!

 

[Beetle]

You need to enter an argument in the Where Condition of the macro
(under Action Arguments). Let's suppose that the field you want to use
is a PK field called CustomerID. The argument might look like;

[CustomerID]=Forms!YourForm![CustomerID]

 

[NDClark]

I entered [SurgeryID]=Forms!Surgery![SurgeryID] on the Where Condition of
the macro. Now the editing form opens up not to edit but to add a NEW entry.

You need to enter an argument in the Where Condition of the macro
(under Action Arguments). Let's suppose that the field you want to use
is a PK field called CustomerID. The argument might look like;

[CustomerID]=Forms!YourForm![CustomerID]
--
_________

Sean Bailey

I have a macro set to open another form (Edit Form) to edit data found on a
Multiple Item Form. The problem is the (Edit Form) always opens to the very
first record. I would like the form to open the record I click on. Would
someone give me some suggestions as to what I am doing wrong?

Please Help!!!
Thanks!