Can anyone help with this please?
I have a table containing data on contracts for various dates for various people
I can run a query to find the ID for any contracts for a given person on a given date (no more than three contracts for a given person on any given date)
I then want to use the ID to open a Contract Display Form
How can I get the ID from the Query into the Macro or Code to open the corresponding Contract Display Form?
Any help would greatly appreciated
AlanL