General information
Category:
Coding, syntax & commands
>Just 2 questions:
>1. Will I not have the same problem with 'calling thisform.' from interactive >change ?
No, InterActiveChange is an event.
>2. Why would I need to set the Rowsource again as it has already been set ?
I don't believe your code will run as written so the Row Source will not be set. The SELECT statement that will evaluate to a RowSource is run as CboBox2 is initialized, but it refers to form container object that hasn't been initialized yet as the form's Init() Event runs after those of its contained objects.
The choices to be displayed in CboBox2 aren't known until the value of CboBox1 is established. Every time the user changes the value of CboBox1, the RowSource of CboBox2 must be reset and requeried.
John
Previous
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