When is Record Source Updated

[Bill Sturdevant]

If you use code to modify a Record Source for a combo box,
do you have to do a Requery, or does the record source
activate upon clicking on the combobox selector?

 

[Bill Sturdevant]

Boy, I guess it is getting too late in the evening to be
asking questions! I meant rowsource, not record source!

 

[Allen Browne]

Try it Bill.

Add a command button on your form that does this:
Me.MyCombo.RowSource = "SELECT * FROM MyTable WHERE (False);"

Does that eliminate all entries without a Requery?