option button

[Young20]

I have a table that has 300+ peoples names on it. Each of these people has a region they belong to 1,2,3,or 4. I also have a form that has 3 combo boxes that are linked to this one table. This information is sensitive and can change by importing new data as well. Is there a way that I can add 4 option buttons, depending on what the user clicks on Opt1, 2, 3, or 4... that is what populates the combo boxs? This seems rather simple, but I can't figure it out.

 

[WinDancer]

Just to get you started-
Yes, you can do that, and fairly easily.
Rather than set up boxes you must use the 'option group' feature.
Be sure that your wizards are turned on.
If you move your mouse across the top menu pictures you will see one that says "Option Group".
When you put the option group on your form the wizard will walk you through the steps required to get it active.
You can then go to your tables and queries to include the new fields and how they affect your record choices.
It takes longer to explain than to do- you will get the hang of it quickly.
Someone else may have some other info for you, but this should get you started,
HTH,
Dave