I have a form using a query looking at 3 tables to populate it. In some of the tables I have fields that are populated from combo boxes with their own recordsources (sql of look up tables containing the code to store and a description. I display the description and use the code as the bound column).

My problem is that I can add a record but cannot select a value from the combo boxes. However, if I exit the form and re-enter the record just added then the combo boxes work as normal.

Any ideas

When you add a record you can do a refresh of the associated combobox (cboData.Refresh).

-Phil-