Checkbox to populate other fields

L

lavenderfleur

I am a beginner with Access, so please forgive my ignorance. What I am
hoping to do is insert three checkboxes on a form. Each checkbox would
be for a group of fields When I check one of the boxes, I would like
it to populate a set of other fields on the form. What this is for is
to enter bid prices and specs for three different vendors and checking
the box would select one of the vendors as the "preferred vendor". I
hope this makes sense. Is it possible to use a checkbox for this
purpose or am I totally off base?

Any help will be greatly appreciated.
 
S

Steve Schapel

Lavender,

If you want to indicate one of three vendors as the "preferred vendor",
then one way to do this on your form would be to use an Option Group,
containing 3 Option Buttons or Check Boxes. This would indicate just
one 'PreferredVendor' field in the table that the form is based on, and
would probably be preferable to three separate checkboxes.

One thing to think about at such a point is whether it is likely that
there will be more vendors to choose from in the future, or whether it
will always be the three. This will influence the decision over the
best way to provide the choice.

It is normally best to focus on the design of the tables to get your
data structure right, before even thinking about your forms. If I may
be so bold, it sounds like you may be doing things the other way around.

Can you give some specific details, with examples, of what you mean by
"populate a set of other fields on the form"?
 
Top