How do I save data created in a form in Access 2003 when I reference other tables?

Question

I'm not sure how to fix this issue, but when I utilize combo boxes on my form which selects data from multiple tables I'm not able to save any of the data selected.

I tried to use the Bound form utility but it only asked me to "Enter Parameter Value". I took out the "Bound" portion of the code and the combo box works fine.

I have a nice little save button, but it doesn't actually save anywhere.

I tried using a query, but that didn't fix it either unless, of course, I didn't do the query correctly.

Here is the "Row Source" information...

SELECT SubArea.SubAreaID, SubArea.SubAreaName, SubArea.ProductName FROM SubArea WHERE (((SubArea.ProductName)=Forms![Combo Form]!Product));

Do I need to put something in VBA or perhaps a Macro to have all the data selected to actually save into a table??? HELP!!!

Thanks

Answer 1

For the Bound Form

Open the form in design mode, right click on the combo box and go to properties. Check out if it is actually bound to something in the Control Source field.

Answer 2

I'm skeptical whether you really need to store all those field values in another table. You can store just the SubArea primary key value (SubAreaID?) in the other table. Then whenever you need to display the other fields (SubAreaName and ProductName?) associated with the stored primary key, use a query with an INNER JOIN (on the primary key) between SomeOtherTable and SubArea.