Jim (or James if you prefer),
Here's a few ideas. If none of these are correct, give us a few more details to work with and we'll try again.
Check the code in the Back/Next buttons to see if it is doing a refresh. Also, the pageframe may be designed to load only the controls on the first page, leaving the other page controls until each page is activated for the first time.
As for the combos particularly, Do they all have the same SQL record source as well as the same name? (Name should make no difference in any code.) When is the SQL for the combos run? In the Load()? Form Init()? Combo Init()?
Perhaps you could step through the "Next" code with Debug to see if the combo is requeried at some point.
HTH
Barbara
>Hi,
> I'm having some problems with drop-down combo boxes. I have set up a page frame with 10 pages, each of which has a drop-down combo box with the same name. The only way to switch between pages in the page frame is via a wizard-like navigation command group (the ones with "<< Back" and "Next >>") The rowsourcetype for each combo box is an SQL select statement. Here's the problem.. Every time I switch between pages, I get the "Cannot access selected table" error. Is there an implicit refresh or requery of form controls when you switch the active page in a page frame? If I'm using an SQL select, do I need to keep the tables open all the time? Any help you can provide would be great! Thanks.