Relational Databases with MS Access
1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run
2) Your code (for the button) will dynamically read the caption from the table and assign it to the button
HINT: Variables (table name) in other areas of the code should not be "hard-coded". If for example a Table name changes in the database it should be reflected in the menu. I do not need to go into the code and look for all entries for the hard-coded name of the table. Dynamic caption means should the name of any table change - the caption on the button for that table must change as well. Test it out ...
3) Your code (for the button) will dynamically read the form/report name and will run when you press the button.
I wrote database and table stumped after that......below are my professors remarks what i need done
When I change an entry in the MainMenu table, I should see that change in the buttons, I do not. Please update and I will update the points.
Attachment:- Info_Rmessman.rar