[MS_AccessPros] Passing Variable Value to QBE grid

 

Is it possible to pass the value stored in a variable to a criteria box in a Query designed using the Query Design Wizard?

For example, let's say I have an option button group on a Form for male or female and a variable (gender) that stores the result of the gender selection.  I create a Query using the Wizard that has a field called StaffGender from the table.  I want to store what was selected on the Form and then pass what was selected to the Query so I only see the records of either the males or females.  Can I pass the contents of the gender variable to the criteria spot under the StaffGender item in my Query?

Dan

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2
• New Links 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___