General information
Category:
Forms & Form designer
Title:
Combo box questions...
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only