T
tim
I have a main page Form with command buttons to show either Company A details
or to show both Company B & C details.
(just used event procedure and ran a filter macro for the Company name)
This event procedure loads a general details form with the filtered results
Showing ie it shows just Company A details. There are several command
buttons on this form and on every other form so that I can navigate to the
other forms that show different details.
When I select a button I want the loaded form to show the relevant Company x
details for the current record.
Ie. I select Company A details, a General Form loads showing the details of
the first person in that company. Lets say I navigate through the records to
record 5 and this pertains to a ‘John Doe’s details. Now if I select a button
to show me his address details then that’s what I want to see, not record 1
address.
So I think I need a way to set a common variable when I select one of the
‘Company’ buttons and then use the variable name in a macro filter ?
I dont want 2 db's because of queries that need to list people from all
companies
Please can anyone help
Thanks
or to show both Company B & C details.
(just used event procedure and ran a filter macro for the Company name)
This event procedure loads a general details form with the filtered results
Showing ie it shows just Company A details. There are several command
buttons on this form and on every other form so that I can navigate to the
other forms that show different details.
When I select a button I want the loaded form to show the relevant Company x
details for the current record.
Ie. I select Company A details, a General Form loads showing the details of
the first person in that company. Lets say I navigate through the records to
record 5 and this pertains to a ‘John Doe’s details. Now if I select a button
to show me his address details then that’s what I want to see, not record 1
address.
So I think I need a way to set a common variable when I select one of the
‘Company’ buttons and then use the variable name in a macro filter ?
I dont want 2 db's because of queries that need to list people from all
companies
Please can anyone help
Thanks