Which choice did he make?

[Yannick Turgeon]

Hi,

I'm using A97.

I've got a table which represents choices a user can select. Now, what I
want is to create a form that show these choices and give the possibility to
the user to choose one or more in the list and then do a certain work on
each of his choice.

Ex:
NoID Product
------ ---------
1 Apple
2 Chicken
3 Lettuce

Those choice will changes regularly so I don't want to hard-code them in the
form. The user can then select one, two or three of these choices by
clicking a checkbox. I would like to retreive items he choose.

How can I do that?

I have no problem creating a form with a Detail section and a checkbox for
each choice but how can I know which are checked when the user click on the
final "OK"? Any other suggestion?

Thanks for your time.

Yannick

[Chuck Van Den Corput]

On Fri, 11 Jun 2004 10:50:05 -0400, "Yannick Turgeon"
<no****@nowhere.com> wrote:

Hi,

I'm using A97.

I've got a table which represents choices a user can select. Now, what I
want is to create a form that show these choices and give the possibility to
the user to choose one or more in the list and then do a certain work on
each of his choice.

Ex:
NoID Product
------ ---------
1 Apple
2 Chicken
3 Lettuce

Those choice will changes regularly so I don't want to hard-code them in the
form. The user can then select one, two or three of these choices by
clicking a checkbox. I would like to retreive items he choose.

How can I do that?

I have no problem creating a form with a Detail section and a checkbox for
each choice but how can I know which are checked when the user click on the
final "OK"? Any other suggestion?

Thanks for your time.

Yannick

Instead of check boxes (which would work if the choices were static),
use a listbox whose rowsource is a query based on your table of
choices. Specify that multiple items can be selected (the default is
just one item).

Then use VBA to determine which items in the listbox have been
selected and then take the appropriate action.

Chuck