J
JimS
I've got a form that's bound to a transaction table. In the header, I have
some combo boxes that are used to filter the form:
me.filter="VendorID = " & cbVendorID
me.filteron=true
me.requery
Works fine on open. Then, I have several more combo boxes that could further
narrow the form. They seem to work ok, too.
Then, I have a button that adds a record to the form using ADODB sql. The
add stuff is entirely standalone, connecting to the backend db, then
inserting the record, then disconnecing (closing) the connection.
After a successful add, I requery the form. No change. Even though the new
record is, by definition, within the bounds of the filter. If I close the
form and reopen it, the new record shows up. I've tried requery,filter off,
requery again, filter on, requery again, no dice.
What's up?
some combo boxes that are used to filter the form:
me.filter="VendorID = " & cbVendorID
me.filteron=true
me.requery
Works fine on open. Then, I have several more combo boxes that could further
narrow the form. They seem to work ok, too.
Then, I have a button that adds a record to the form using ADODB sql. The
add stuff is entirely standalone, connecting to the backend db, then
inserting the record, then disconnecing (closing) the connection.
After a successful add, I requery the form. No change. Even though the new
record is, by definition, within the bounds of the filter. If I close the
form and reopen it, the new record shows up. I've tried requery,filter off,
requery again, filter on, requery again, no dice.
What's up?