Combo box issues (Access03)

Topic

New Reply

I have put two combo boxes on a form. I had them pull data straight from two tables with the data being entered into two other tables. Something we do daily, but I guess I don’t remember how, because the crazy things bongs me everytime I try to use it. Properties include:

Count: 1
Width: 2″
Bound 1 (there is only one item on the grid)
Row Source Type is Table/Query, Row Source is SELECT tblDepartments.Department FROM tblDepartments ORDER BY tblDepartments.Department
Limited to List: Yes
Enabled: Yes
Locked: No

So what am I not seeing this late in the day?

Thank you.

Fay

Reply | Quote

Replies

Is the combo box bound to a field?

Reply | Quote

Yes in both cases.

Reply | Quote

Could you post a stripped down copy of your database? See post 401925 for instructions.

Reply | Quote

Thanks Hans.

Reply | Quote

Your setup is unfortunate. You shouldn’t store the department name as a text field in the tblLearnerDepartments table, but the DeptID as a numeric field, and similar for the other fields for which there is a numeric ID such as Position and Credentials.

And you shouldn’t use a single form to enter learners and learnerdepartments. Use a main form based on tblLearners to enter/edit learners, and a subform based on tblLearnerDepartments to select one or more departments for the learner.

See post 364,203 for an example of how to handle data entry for a many-to-many relationship with a main form and subform.

Reply | Quote

Okay. Thanks. I had started to do the form/subform route. I will go back to it. Fay

Reply | Quote