Item on Combo Box doesn't appear

[aziz rasul]

I have a pop up form with a single combo box. The Row Source is based on a query.

On the Open event I want to have the combo box item "General Enquiries" to appear. I have tried: -

Me.cboSwitchboard = "General Enquiries"

but the combo box shows nothing when the form is opened. If you select "General Enquiries", then it's OK. Can anyone see why this should happen?

 

[Alansidman]

What happens when you set the default value for the combo box in properties to "General Enquiries"?

 

[aziz rasul]

Still doesn't work.

 

[jal]

I read somewhere that some of the Form-startup events can clash with each other. Maybe try the Form_Load event.

 

[jwhite]

1. Is the Combobox Bound to a field from the Form's RecordSource?
2. What is the RowSource of your Query?
3. Does it return more than 1 field?
4. What is the Bound Column?
5. Is it by chance a Numeric Value representing a Primary Key for the text values in another table?
6. If so, then you will need to assign it the PK Value instead of the text.

Otherwise, OnLoad as Jal recommended sounds sound.

 

[aziz rasul]

Found the problem. The combo box was bound to the first column which was a number whilst I was assigning it to the second column. Thanks guys for your help. I'm feeling pretty stupid now.

 

[jwhite]

No need to feel stupid at all! Happens to all of us at one time or another.