Changing rowsource of Listbox

  • Thread starter Thread starter David
  • Start date Start date
D

David

When I change the rowsource of a listbox in the ACTIVATE
event, does it do an automatic REQUERY?
My control seems to be being requeried twice.
 
David said:
When I change the rowsource of a listbox in the ACTIVATE
event, does it do an automatic REQUERY?
My control seems to be being requeried twice.
Click to expand...

Yes. Changing the RowSource property of a control forces an automatic
requery of the control, and changing the RecordSource property of a form
forces an automatic requery of the form. There is no need to do an
explicit requery after changing the property; if you do, the query will
be run twice.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bug With Rowsource Property on Listboxes and Comboboxes? 1
More on List Boxes 12
Listbox SQL problem 2
BeforeUpdate or ValidationRule property... preventing saving data in field 0
Why doesn't preselecting my listbox record from VB work? 2
Requery not working 8
List Boxes Do Not Requery 5
Go to ItemID in listbox? 1

Back
Top