checkboxes on a form

[JChandler22]

I'm rather new to access... bear with me here!

I have a field in my Contacts table called "Sports," and I have another table called "Sports" that has a list of specific sports, ie Soccer, Baseball, Lacrosse, Basketball, Swimming. I have a form set up for the user to add records (info about kids and what sports they play).

On that form, I would like to include a bunch of checkboxes next to the specific sports from the "Sports" table so that the user can check one or more sports that the kid plays.

How do I achieve this?

Thanks,
JChandler22

 

[kabz]

I'm rather new to access... bear with me here!

I have a field in my Contacts table called "Sports," and I have another table called "Sports" that has a list of specific sports, ie Soccer, Baseball, Lacrosse, Basketball, Swimming. I have a form set up for the user to add records (info about kids and what sports they play).

On that form, I would like to include a bunch of checkboxes next to the specific sports from the "Sports" table so that the user can check one or more sports that the kid plays.

How do I achieve this?

Thanks,
JChandler22

Surely that must be simple to do.Just switch your form to design view and add Check boxes and the Source Control should point to your specific fileds e.g Soccer.

 

[maxmangion]

Hi,

On that form, I would like to include a bunch of checkboxes next to the specific sports from the "Sports" table so that the user can check one or more sports that the kid plays.

Considering that there are hundreds of different sports, your approach is going to lead you not with bunch of checkboxes, but probably with "too many", where for each record you might end up having 30 or even more checkboxes and maybe only 1 or 2 of them selected.

You should consider creating a junction table between your main table and the sports table, and create the records there.

For example

main table:

person1
person2
person3
person4
etc

sports table:

soccer
snooker
basketball
golf
etc

junction table:

person1 soccer
person1 golf
person2 basketball
and so on.

Hope this helps.

 

[kabz]

>>>Surely that must be simple to do. Just switch your form to design view and add Check boxes and the Source Control should point to your specific fileds e.g Soccer<<<

Hi Kabz,
That means you would need a table with one field for each sport, this is not a good idea for various reasons.

One reason is that if you add a new sport, then you need to add a new column in your table, not a good idea!

The other problem is when you come to create a query to find out which students participate in which sports, then you definitely have a very big headache!

MS Access supports subforms, it is one of its major advantages, the subform automatically links to the main form, giving you a very high level of interaction without any programming in many cases.

Just what having thinking about my post"Subforms" yeah that was not a good approach sorry Chandler,i hope you understand what UncleGiz is trying to put across

 

[JChandler22]

Very helpful Uncle Gizmo, thank you!