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