When does a combo box update the record source assigned to it?

[JimMiller]

When does a combo box update the record source assigned to it? Does it wait until the form is closed or does it update after the new value is selected? Also what event corresponds to the updating of the record source associated with a combo box?

Any insites or information will be extremly helpful.

 

[David R]

I just discovered (with the help of another topic here) a very cool help file yesterday: 'Find out when events occur'. There is a section on 'Order of Events for Controls on Forms', and a subheading about 'Changing and updating data in a control'. This should answer all your questions.

Note, this is in Acc2K, don't know about earlier versions.

HTH,
David R

[This message has been edited by David R (edited 01-31-2002).]

 

[JimMiller]

Thanks for your post!

Do you know when controls are unavaliable/out of scope for queries and calculations?

 

[David R]

Sorry, that's out of my scope.

David R