Populate Radio Buttons from Database record

[CementCarver]

I'm trying to build a database of car dealers while using Access 2010. They only sell three types of cars. Once the user select which car dealer they want to look at, I hoping to populate three radio buttons based on values from the database. From what I've read, it seems that the radio button, while using the option group wizard, that the radio buttons are meant to populate a database field, rather than having the database record populate the radio button.

Does anyone know how to do this, so that I am able to show three radio buttons in my form to show which three types of cars this specific car dealer sells?



Any help would be appreciated.

CementCarver

[orange]

Show a mock up exactly what you want.

Also I think They only sell three types of cars. is extremely limiting and very subject to change. If this is an academic exercise, then great. But if this is a serious design element for your database, then rethink your options and scope.

[CementCarver]

Actually I cannot disclose the data that I'm working on, due to a confidentiality agreement. I was only trying to provide a parallel scenario. Rather than using car dealers as an example, let's say I have a producer who can either produce product a, product b or product c, or any combination of the three. I was thinking of linking subforms for each of the three products, but if the producer only produces product a, then other other two subforms would not contain any data. Therefore, I was thinking that if I populate three radio buttons to display which of the three products they produce, that would give the user a visual indicator as to which form would contain data.

If there are better ideas, I open to suggestions.

[orange]

How about 3 choices in a combo box?
Do you have a specification for what you are trying to design and build?
Do you have a data model?

Seems to me you may be way ahead of your self with subforms...

Here's a generic guide to Better Databases
http://www.rogersaccesslibrary.com/f..._Databases.zip

[CementCarver]

thx Orange. Yes, I do have specs and a data model, but I will review the attached .zip file for more ideas.

[orange]

There is a sample in the tutorial which should help.
As for your own data/set up, I think you can get a generic analogy and communicate with the readers.

Do your analogy in terms of People, Projects or whatever to give us the general info. Nobody here wants anything confidential, but we need something consistent, if we are to help.