I've searched around for answers, but the closest thing I've found referenced the Northwind database and it seems to be set up a little differently than mine.
I'm using DAPs (data access pages) for my user interface, but I'm not sure that the method will be much different than forms (except for some of the property names). I think my understanding or background knowledge on the subject is just lacking.
I have an option group that I created and I have placed 2 option buttons (Action and Other) within it. Actually, I think I may have copied them from another database, but the names and labels are all the same and I've modified the properties to fit this database.
I have changed the Value property of the option buttons to 1 and 2, respectively. Neither of these buttons has a control source.
My frame has a control source of ProblemType on a table I'm using as a container for data, called tblData_Log. I have another table, called tblProblem_Type, that has 2 problems (Action and Other) with an ID number associated to each.
When the user clicks on one of the option buttons, the value (1 or 2) should be stored in the frame, and then it should reference the tblProblem_Type to change the number into text and store it on the tblData_Log.
The help documents I've viewed on MSDN and through MS Online mention that storing a text value is possible if you refer the Value number to a separate table and make a lookup field in the table where the name needs to go. I feel like I've done this, but the value isn't appearing. Also, the dropdown box shows the ID number and the Problem, instead of just the problem.
Here's the SQL I have entered for the ProblemType field in the tblData_Log:
Expand|Select|Wrap|Line Numbers
- SELECT [Problem_Type_ID], [Problem_Type] FROM tblProblem_Type ORDER BY [Problem_Type] DESC;