SubForm Auto Update to a Table

[frog40]

I have a food menu program with many restrictions due to our User clientele. The User is allowed to see only what we choose and not the whole table. This is what I have:
The User can have 3 choices of 3 different menus (Option Group). Inside each OpGrp the User can see menu items for that group only (Unbound List Box from a Lkp tbl). If Opt1 is chosen, then a previously invisible (SubMenu)Table (Database View) with Check Boxes will appear, allowing the User to select items (from 1 to 10) via check boxes.

If the User changes his mind and selects Choice2, then everything that is now visible for Choice1 disappears and becomes null. The items now appear for Choice2 (in the same manner as described above).

This all works fairly well, until another User (who will Maintain this program) needs to change the menu items. I need some way for the Maintainer to change the item in the LkpTable and then be AUTOMATICALLY entered into the Selections Table (tblName used for the SubMenu), then have these changes show up on the SubMenu Check Box Table.

I used Check Boxes because I will eventually need to count each item and also need a complete report for each individual User.

I am limited on my knowledge of understanding how to put VBA Code together and also whether to put it in a current Private Sub or to create a new one.

Any help will be greatly appreciated.

 

[genomon]

Have you looked at cascading updates in table relationships?

I wondered why the baseball was getting bigger.
Then it hit me.

 

[frog40]

Genomon - Yes I do have this checked to Cascade Updates. However, it did not work. Maybe I am missing something here (besides the baseball). After I checked this option I went to my Lookup Table and added a new item. I then went to the fSubMenu to see if it automatically put it in the selection. It did not.

What am I missing?

 

[frog40]

I forgot to add this piece of the puzzle. It did update the Unbound List Box, but not the fSubMenu. How do I get this to go a step further AUTOMATICALLY.

Thanks for your response