Robin has attended:
Access Intermediate course
Access Advanced course
Applyfilter problem
I have a query that simply looks at a yes/no field and if my continuous form shows it "ticked" it filters those records out. It also sorts by date at the same time.
I can run this as a form filter from the access menus easily enough by "loading from query" but here is the problem:
I have an option control with 2 choices on the form, one to run the filter query and one to reset it to all records.
Here is the line for "option 1"
DoCmd.ApplyFilter "qdfcurrmessages"
The fact that I am telling it use qdfcurrmessages seems to be ignored.
It just runs whatever the last filter that was used via the access menus.
A simple solution will let me sleep!
Thanks
Robin
RE: Applyfilter problem
Hi Robin,
We'd really need to look at your database to fully understand your problem. Even then, it would take quite a while to track down the problem and come up with a simple solution, and may require organising a consultancy day for you.
If you like, send the file to forum AT stl-training.co.uk and we can decide whether a consultancy day is required (no obligation).
Or, you may come up with a solution on your own after attending our Access VBA course and learn even more at the same time!
Regards, Rich