Link to home
Create AccountLog in
Avatar of SparkyP
SparkyP

asked on

Toggle Filter with Command Button

I have a form which logs engineers jobs. On the form is a field "Status", which has 3 options, In Progress, Completed and Invoiced.

What I want to do:

Open the form only showing records that are In Progress and Completed.

Have a command/toggle button that allows me to filter only In progress record, and then return to the In progress and Completed records.

I also need the facility to view all records i.e. including Invoiced records.

Many thanks in advance
Avatar of Thommy
Thommy
Flag of Germany image

Use filter buttons for each status...
Filter Access forms with one button
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of SparkyP
SparkyP

ASKER

IrogSinta

I'd like to think I have done what you suggested, but crashes when I pick any option.

Also added Dim strFilter as String

Anything you may suggest I may be doing wrong?
Do you get an error message?
Avatar of SparkyP

ASKER

No messages, but I think I have a bigger problem. MY DB crashs when I use the buily-in Filter. Need to do some investigation. But thanks so far, I'm sure it will work when I am sorted.
Avatar of SparkyP

ASKER

Irogsinta

Works like a dream. Many thanks.