Query on form does not work when exported to new mdb

  • Thread starter Thread starter JimP
  • Start date Start date
J

JimP

A query (SQL string) is the source for a list box and there is a toggle
button on the form that modifies the query. The toggle button on the form
has no affect until the query is simply viewed in design or datasheet mode -
then it works fine.
 
In the code where the SQL string is modified, you need to requery the list
box after the SQL has been changed:

strSQL = ....

Me.MyListBox.Requery
 
Actully, the toggle button performs a DoCmd.Requery with no affect. I'm
inclined to think something is corrupt, yest I've done a compile on the code
and a compact with no positive results.
 
I don't think it should matter, but I would not use the Docmd. I suggest
trying the syntax I posted.
 
Back
Top