Filter problems on from

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem with one of my forms. When i open the form no records
appear. The only way i can get data to appear is if i filter by selection.
I get an error saying that there is a syntax in the query for the filter.
However when i close the error box and remove the filter using the toolbar
button all the records appear. Now the strange thing is that i have not
changed anything in this form in over a week, and no one has access to the
file at all. Is there possibly something that might have happened to this
file? Should i return to my last backup and redo my changes up until the
point i am at now?
 
JKarchner said:
I am having a problem with one of my forms. When i open the form no
records appear. The only way i can get data to appear is if i filter
by selection. I get an error saying that there is a syntax in the
query for the filter. However when i close the error box and remove
the filter using the toolbar button all the records appear. Now the
strange thing is that i have not changed anything in this form in
over a week, and no one has access to the file at all. Is there
possibly something that might have happened to this file? Should i
return to my last backup and redo my changes up until the point i am
at now?
Click to expand...

If your form has its DataEntry property set to Yes or if you open the form
via code using the acAdd argument then it will always appear blank and not
show existing records.
 
well i thought that had worked, but it did not. when i closed the file and
reopened it i had the same problem. are the filters supposed to save when
you delete them from the Filters: field? i did that and then saved the form
and yet they still appear there. if you have any more suggestions that would
be great. thank you
 
I found the problem. I had been using a switchboard and i accidently set it
to open the form in add mode instead of edit mode. Thank you for your help
 
Back
Top