1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run
use the information in the materials section to create the table
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.
Sample Solution