Form OptionGroup filters a report

Geordie2008

Registered User.
Local time
Today, 04:12
Joined
Mar 25, 2008
Messages
177
Hi All,

On my main switchboard and I am designing some reports that the user can open.

On the switchboard form I would like to give the user several options which will then filter the reports...

So I have:

Employee Indicator: [Employee] [Non-Employee]
Employee Status: [Active] [Inactive]

i would like to be able to allow the user to decide if they want to run a report by Country (for example)

By all people who are "Employees" and for both "Active" and Inactive"
By all people who are "Employees" and are "Active"
By all people who are "Non-Employees" [and therefore are "Inactive"]

I have designed the option boxes as follows:

Employee Indicator:
[Employee]
[Non-Employee]
[Both]

Employee Status:
[Active]
[Inactive]
[Both]

but when I look at it in form view, it will not even let me select an option?!!?

Also, do I need a "Both" option? Or can I leave it blank and then return all..

Has anyone done anything similar? I cant find anything using the search function on this forum.

Many thanks for reading!
Mandy.
 

Users who are viewing this thread

Back
Top Bottom