Combo Box Not Linking

[Gee...]

I have 2 combo boxs, amoung various other controls, in a form linked to a
database. When I fill out the form, the correct choices are on the drop
down. I choose what I want, fill in date fields, check boxes, all the other
stuff and Submit.

Everything updates to the Access db, except the Combo Boxes. They're blank
in the db.

Both Combo Boxes have their own table, then are joined, through a Query, to
the main Access Qry that the form is updating to.

Thank you in advance for your help.
Gee

 

[Gee...]

I figured it out.
For anyone else who's seen this, I had the "Limit to List" on the controls
in the Access database set to "Yes".
I changed things around and set them to "No" and it submits just fine now.