P
PeterM
I'm running Access 2003.
On my form I have a listbox that I'm populating with customers. When the
user clicks on an entry in the listbox, the customer name is used to query
the customer record. All of the fields for a customer are on the same form.
The rowsource for the customer query (not listbox query) is "select ....
from... where customer = me.listbox.column(0). That part works great...it
finds the customer record and displays the fields on the form.
The problem is that when the user goes back to click on another entry in the
listbox to see another customer, it requeries the listbox and then displays
the customer record on the form. It doesn't requery the listbox the first
time, but it does requery the listbox every time afterwards. I have now
me.listbox.requery or me.listbox.rowsource statements anywhere. It's doing
it on it's own. I don't want it to automatically requery, I will control
when that happens.
What am I doing wrong? thanks in advance for any help...........
On my form I have a listbox that I'm populating with customers. When the
user clicks on an entry in the listbox, the customer name is used to query
the customer record. All of the fields for a customer are on the same form.
The rowsource for the customer query (not listbox query) is "select ....
from... where customer = me.listbox.column(0). That part works great...it
finds the customer record and displays the fields on the form.
The problem is that when the user goes back to click on another entry in the
listbox to see another customer, it requeries the listbox and then displays
the customer record on the form. It doesn't requery the listbox the first
time, but it does requery the listbox every time afterwards. I have now
me.listbox.requery or me.listbox.rowsource statements anywhere. It's doing
it on it's own. I don't want it to automatically requery, I will control
when that happens.
What am I doing wrong? thanks in advance for any help...........