Populating Combo Boxes - why doesn't this work all the time?

[amorts]

I am using the following code to populate some of my combo boxes;

Private Sub form_Open(Cancel As Integer)
With combFilter
.RowSourceType = "Table/Query"
.RowSource = "<Name of Query>"
End With
End Sub

I find that this is quite tempermental. If works for some on some but not on others. I have ran the query and checked it produces the desired results. However, when I drop down the box in run time it is blank.

Any ideas?

 

[VicRauch]

You show .RowSource = "". That is not a query. and therefore nothing would ever show up in your combo box.

 

[amorts]

Sorry I forgot the tags on here would have taken that out.

I actually typed .RowSource= "qryName" but I put optional brackets around it originally!

 

[VicRauch]

Could you post the SQL for the query? If it works by itself, but not for the combo box, the SQL would be a help to understand what is going on.

Something else to look at is the properties of the combo box. How many columns do you have defined, and which of these columns do you have set to a width of zero, for non-display of that column?

 

[Norie]

Is qryName the actual name of the query?

Or is it a variable holding the name of the query?

 

[amorts]

It's really strange I have just deleted and recreated the combo box and done the same with the query and it has now decided to work.

I had this same problem yesterday too!

Thanks for your help though guys.