Access 2007, moderate skill level, not compiled, not split, no errors. I need to select the active record in data sheet and launch a modal form based on a query of the record selected.
I have a Main Form which has criteria the end user selects, MealName, StartDate, EndDate and then clicks Find Records button and the data sheet returns the queried data.
The end user needs to select the record they want, and pick a new Food Item to replace the existing item. A lot of inventory data has to change to reflect the change in Food Item.
I would like the end user to select the row he wants to change. And somehow (this is what I am looking for) launches a Modal Form calling up all the fields of the selected row. Then he can select the Alternage Item on the Modal Form and all the data associated with it. Then when he is happy with his selection on the Modal Form he can click an update button and run an Update Query replacing the data in the Active Record.
See Picture
I am unsure how to reference the active row in the datasheet or how to launch a form in some manner from the selected row. I can obtain the Primary Key of the data sheet to make the update query exact.
Thanks
Fred