Check boxes

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

Guest

I have a tabke with items A thru Z
I have another table with Categories like Fruit, Nut,
Veggie.

I would like to create a form to list all the items (A to
Z) with check boxes for Fruit, Nut and Veggie. Depending
on what is selected, populate the Items table with the
correspoding entry. Example:

Form
Fruit Nut Veggie
A check box check box check box

If the user checks Fruit for A, table A has field category
populated with F.

How do I go about it?

Thanks
 
If I understand you correctly, I think I would do one of these...

On the Items form, put a Combobox for the Category field, with its Row
Source set as the Categories table, and then foe each item, you select
the category from the combobox.

Or, on the Items form, put an Option Group for the Category field, with
an Option Button for each possible Category, and then foe each item, you
select the category from the Option Group. This means that the actual
data for the Category options as stored in the table will be a number,
corresponding to the option value of the option button selected. But
this doen't matter, you just need to convert it somehow to the form you
need to se it for your forms and reports.

Which of these you use will depend on a few things, for example how many
options there are for the Category, and the likelihood that new
categories will need to be added as time goes by.
 
Thankyou ... that is exactly what I wanted!!
-----Original Message-----
If I understand you correctly, I think I would do one of these...

On the Items form, put a Combobox for the Category field, with its Row
Source set as the Categories table, and then foe each item, you select
the category from the combobox.

Or, on the Items form, put an Option Group for the Category field, with
an Option Button for each possible Category, and then foe each item, you
select the category from the Option Group. This means that the actual
data for the Category options as stored in the table will be a number,
corresponding to the option value of the option button selected. But
this doen't matter, you just need to convert it somehow to the form you
need to se it for your forms and reports.

Which of these you use will depend on a few things, for example how many
options there are for the Category, and the likelihood that new
categories will need to be added as time goes by.

--
Steve Schapel, Microsoft Access MVP



.
Click to expand...
 
Back
Top