I am just getting my feet wet in Access. I have two tables and one form. In the form I have a combo box which holds selections from one table. I would like users to be able to choose a selection from the combo box the enter a entry in the following field. When clicking save I would like this field plus the ID of the item selected in the combo box stored in a table.
I am attaching an example as it is far easier to show than explain. Any help would be greatly appreciated.
Thank You!
I am using Access 2007
Bookmarks