Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Checkboxes ApplyFilter action using Macro!

Status
Not open for further replies.
Jeddiah

Jeddiah

Programmer
Apr 30, 2002
17
US
I'm having a problem with a form that have checkboxes that uses a macro to open a report. I keep getting the error message when the report opens. My unbound form has a option group (Group1) that with the labels listed below and their option value:
Mailclerk=1, Inventoryclerk=2, Janitor=3, Carpenter=4, Printer=4. When one of these jobs are checked, I want to preview my report(ClientSkillsList) and view only those clients that has that selected skill.
My macro is:
Condition Action FilterName WhereCondition
[Group1]=1 ApplyFilter qrySills [MailClerk]=True
[Group1]=2 ApplyFilter " [InventoryClerk]=True
[Group1]=3 " " " [Janitor]=True
[Group1]=4 " " " [Printer]=True

Problem, ApplyFilter not filtering the report.
 
Status
Not open for further replies.

Similar threads

Lamar Washington
  • Locked
  • Question
Programmatically send email using only OWA
Replies
2
Views
312
Andrzejek
Andrzejek
Modex
  • Locked
  • Question
How to Close Desktop Application Windows using VBA
Replies
3
Views
269
Andrzejek
Andrzejek
Kim296
  • Locked
  • Question
FILTER SUBFORM USING MAIN FORM FIELDS- VBA 3
Replies
8
Views
512
Andrzejek
Andrzejek
JayRo71
  • Locked
  • Question
Select records on subform using a combo box with a twist 1
2 3
Replies
56
Views
1K
JayRo71
JayRo71
StevenFromSouth
  • Locked
  • Question
Using .Fields() method in Recordsets for calculations. 1
Replies
1
Views
164
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top