how to create an option box in Access 2000

[thefroggy]

Hi everyone,

I'm a newby in Access, sorry if the question is a bite dump, and I'm not english so sorry if it is not really clear.

I have been trying to create an option box (similar to the YES/NO one) with two different option to choice between two different path. I have manage to do something with a form with two commande option, but it does not like so nice. I would like to have it in a small prompt window.

What I have so far:

Introduction form ( with 10 commande button, click on one)
|
|
New form (two commandes) Step I want to eliminate with box
/\
/ Databasse Other form

Hope this is clear enough, sorry for the graph it is easier to explain my problem that way.

Stephane

 

[randy700]

If I understand your question correctly, what you want is an option group. Let the wizard help you build it. You will have 2 (or more) radio buttons which you can then use for code.

After you build the option group, you'll need to write some code to use the selection. This is normally done on a command button. The two ways I normally use it are.....

1. As a WHERE clause. The command button might call up a report that I want filtered based on the option group selection.

2. In a SELECT statement. The command button might display records on a form that are filtered based on the option group selection.


Randy

 

[thefroggy]

Thanks Randy,

I'll give it a go and keep you inform.

Stephane