Adding a new record to a form

[Ollie_3670]

What is the name of the table your form is linked to?

That's what I was getting at ^^

---

If you've already tried recreating the form by binding it to the correct table then I have another suggestion involving list boxes

do your combo boxes just contain a number of values that you have input yourself which you believe will commonly be used?

 

[RobMoo]

My form is bound to another table called QUOTES and my combo box is attached to to a query. Combo 1 contains a list of airlines and combo 2 contains the aircraft fleet of the selected airlines... so when I select an airline the 2nd combo shows only the fleet of the airline selected in combo 1

 

[Ollie_3670]

are you able to post a zipped version of your DB?

 

[vbaInet]

Well there you go Ollie, we've established that the OP's form's record source doesn't have a link to the combo boxes.

Just one more thing whilst your posting your db to Ollie, are there fields in your QUOTES table to accomodate data from both combo boxes?