When is Record Source Updated

  • Thread starter Thread starter Bill Sturdevant
  • Start date Start date
B

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?
 
Boy, I guess it is getting too late in the evening to be
asking questions! I meant rowsource, not record source!
 
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?
 
Back
Top