Access 2007, not compiled, not split, skill level medium.
The form shows the default MealItems set for production. At the last minute the end user may need to select an alternate meal item, and substitute corn for green beans.
I have it set up so that the end user double clicks on the ItemName field on the data sheet and that opens a modal form with a query behind it.
I want the query behind the modal form to pick up the Meal3ID which is the primary key of the table behind the data sheet. and pull that record from the underlying table Tbl_ScheduledMealItems and display the fields on the modal form.
Everything works fine except:
The double click only calls up the first record in the underlying table. It does not pull up the active record (The one the end user clicked on.)
How can I make my double click on the ItemName field capture the Active Record clicked on and pull up that specific record in my Modal form?
Please see attached pic.
Thanks,
Phred