I am working on a database that is simply storing interview information. The form I am working on has some text boxes from the Referral table and from the Information table. What I am trying to do is to add 2 drop down list boxes for Type and Category. I have created two tables called CaseType and CaseCategory. Inside each of the table has ID (PK), Type or Category, and POCsN.
I have 2 fields in the information table in which I would like the data to be stored based on the Type and Category that is selected. I have created the list boxes and bound the Control Source to Category/Type and the Row Source Type to Table/Query. The problem I am having is when I click on the list in form view, it tells me the box isn't editable and doesn't let me choose. The other problem I have is linking it back to the employee...so I went to relationships and joined the Category.ID to Information.Category and Type.ID to Information.Type. When I do this, I try to revert back to form view and my form is completely white...all the boxes go away.
I have the 2 boxes showing up on the form with the values listed in there...but when you click on them to select what type or category, it beeps and says The recordset isn't updateable. I need to be able to select the type and category...and have the ID #'s store in the information table as 1, 2, 3, etc...in the Type and Category Fields. The type shows up in the type list box as Referral, Case, etc.... so that shows correctly now...just cannot select the one I want.
I have the boxes listing the proper names in them. I have a table called CaseType, CaseCategory, and IncidentInformation. The form I am using is called IncidentInformationSubForm. The boxes are on there and pull the alphabetical names from the table CaseCategory and CaseType. What I want to happen is once it is selected, I need the CaseCategory.ID and CaseType.ID to be stored in the IncidentInformation table in CaseType and CaseCategory fields once I hit the Save button I created at the top of the form. The save button does save all the other information I enter on the form but not the CaseType and CaseCategory. The save button is just simply doing Private Sub cmdSave_Click().....DoCmd****nCommand acCmdSave.....End Sub.
The Control Source is CaseType.ID
The Row Source is SELECT CaseType.* From CaseType;
Row Source Type is Table/Query
Bound Column 1
Allow Edits Yes (as they did request being able to add something if some selects option 'Other'
Any ideas or suggestions?
Last edited by jmonroe; 11-15-10 at 12:17.
Reason: Forgot some info
The main problem does not seem to be in the construction of the combo but rather in the recordset of the form (or in the link between both) and I wanted to see its SQL statement too. Is this recordset updatatable?