Open form on click of detail line in subform 1

[rlf1957]

Hello again,

I have a form/subform (for order data) similar to that found in Northwind db. What I am trying to do is open a data editting form when I click on the OrderID field in the desired subform line.
In the 'On Click' property of the OrderID field of the subform I have inserted a macro name. The macro does an 'OpenForm' usng a form named 'OrdEdit'. Problem is getting the OrdID value into the mix so as to open the form to that Order not the first one in the table.

Any help will be appreciated.
RLF1967

 

[ZmrAbdulla]

Create a command button through the wizard to open the editing form choosing the relation to view data and see the code behind it.

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.

 

[rlf1957]

Thanks for the assistance - it worked great

RLF1957