combo box in form

[wdisneymom]

I made a combo box on a form of Titles of employees
I have a query of Titles of Employees
I know how to put a control box on the form but I can't seem to get it to open that particular query
Can you help

 

[Gram123]

Rather than dragging a new combo box (from the Toolbox toolbar) onto your form and then trying to assign the field to it, drag the field itself from your Field List (on the Form Design toolbar).

The Field List button looks like the attached.
If when you've dragged it to your form it looks like a Text Box, right-click, Change To... > Combo Box.

HTH

Gram

 

[wdisneymom]

Is my problem that I have 2 combo boxex on the same form?? I have a control button that opens a report when I have a particular item selected in the combo box...I'm trying to get the same thing for the other combo box

 

[kfoll]

Is this a criteria selection form you are talking about? In which case the combo box you are using is unbound to any controls from a table or query. If you place the unbound combo box in the forum using the wizard, just make sure it looks up the values from a table or query, choose query, and then choose the query you want it to look up from. Or, if not using the wizard, just click the little arrow beside "row source" and scroll down until you find the query you want.
As for having 2 combo boxes on the same form, it shouldnt be a problem unless the macros that drive them are not set up properly. Make sure there are separate control buttons for each box-- unless the 2 boxes are meant to define a range of data, such as a beginning and ending date, in which case one button would suffice for both.

 

[wdisneymom]

the selection is the "title" of each employee (suervisor, porter etc) and the titles come from a table of the titles...I used the wizard and it still makes me type in the title