Option Group

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

Guest

I am creating an option group for our firms contact database. I have the
following options: Holiday List, party list, mailing list. I want to be able
to choose more than one value in this group. Is there a way to do this or
should I create something else other than an option group?
 
OK did that. But when I fill out a form and check the list/lists i want,
when i fill out the next form and change which lists i want, the first form
doesn't hold what i initially checked. How do i get it to stick with each
form? Also, how do i link the checkboxes to a specific table?
 
Sorry, I don't follow how you want the forms to work.

Generally, you base a form on a table, by setting the form's
RecordSource property to the name of the table. Then, you add a control
to the form, for each of the fields in that table which you want to
appear on the form. You set the ControlSource property of the control,
to the name of the field. You choose a type of control which is
appropriate to the field in question. For a text field (in the table),
you'd choose a textbox (for the form); for a Boolean (yes/no) field,
you might choose a chckbox, and so on.

Does that help?

TC (MVP Access)
http://tc2.atspace.com
 
Thank you for you reponse
What you are describing is what i want to do. The issue I am having is in
the form being able to choose more than one option from the table. When i set
it up as a dropdown I can only choose one option. I just need to be able to
choose more then one option
 
Your original post mentioned Holiday List, party list, mailing list.
You want to be able to choose more than one value from that group.

I do understand that, in principle, but you need to tell me more about
your information before I can help. What thing or things are you trying
to store information about? Wat thing does a single record in your
table, represent? Try to describe it without using techncal terms like
tables, forms or combo boxes /at all/.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
Back
Top