I have a combo box on a 2 page pageframe. I used the form wizard to create the initial form, then added the pageframe and moved the controls placed on the form by the wizard to the pageframe.

I added a combo box to page 1. I used a combo box very similar to the one on the Order Entry form from the Tasmanian Traders sample. This combo box is keyboard sensitive and if the Display value is not in the list it asks you if you want to add it.

The combo box has a RowSource of my Master Table, with RowSource Type of Fields.

My problem is this. If I add a new record to the master table, (through the same form the combo box sits) I cannot access the last record in the combo box even though it appears in the list. Before I thought it was the new record I couldn't access, but I added an index to the table and thought I solved my problem. All n number of records are in the list after a new record is added, however only n-1 records are accessible through the combo box.

I have tried the Requery() method along with everything I can think of including various Refresh() methods. What is also strange is if I click on page 2 then back to page 1, I can then access all records in the combo box.


Thanks in Advance.

Scott