Newbie question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having trouble connecting a form control to a query criteria. In the
query, the user is prompted for input (1 thru 4). I want to setup an option
group with a radio button for each possibility (1 thru 4) and have the query
use the value from the option group as the criteria rather then prompting the
user.

I hope this makes sense.

Ted
 
I'm having trouble connecting a form control to a query criteria. In the
query, the user is prompted for input (1 thru 4). I want to setup an option
group with a radio button for each possibility (1 thru 4) and have the query
use the value from the option group as the criteria rather then prompting the
user.

I hope this makes sense.

Ted
Click to expand...

Code the criteria line of the field in the query:
Forms!FormName!OptionGroupName

Be aware that the value of an option group is a Number datatype.
 
Code the criteria line of the field in the query:
Forms!FormName!OptionGroupName

Be aware that the value of an option group is a Number datatype.
Click to expand...

I forgot to add....
The Form must be open when the query is run.
 
Back
Top