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

N

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!
 
B

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]
 
N

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.

Beetle said:
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


NDClark said:
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!
Click to expand...
Click to expand...
 
Top