Help with option group code

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

Guest

Hi All,

I have an option group (called options) with 4 values in it. I also have a
command button on the page.

What I need to happen is once the user has selected an option and clicked
the command button another window pops up with an input field which the user
than needs to fill out and press ok which will then run a query which is
filtered by the users input. Make sense? :)

Hope someone can help with the code, just a snippet of what is required
would be great.

Cheers,
Andrew
 
Hi All,

I have an option group (called options) with 4 values in it. I also have a
command button on the page.
Click to expand...
What I need to happen is once the user has selected an option and clicked
the command button another window pops up with an input field which the user
than needs to fill out and press ok which will then run a query which is
filtered by the users input. Make sense? :)

Hope someone can help with the code, just a snippet of what is required
would be great.
Click to expand...

The code would be in the AfterUpdate event of the option group
control. You'ld use the OpenForm event to open a second form with a
textbox and a command button on it. The query would have a criterion

=[Forms]![nameofform]![nameofcontrol]

on the user input field; typically you'ld base a Form on this query to
display the results, rather than opening a query datasheet.

Your question doesn't clearly indicate what role the value selected in
the option group plays; is its value used as the search criterion, to
control the message, or what?

John W. Vinson[MVP]
 
Back
Top