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?
