Database query won't refresh from combobox criteria

[fprzekop]

I have a database query (Excel 2003) that is setup with a parameter. The parameter is linked to a cell value, and the cell value is populated from a combobox.

The idea is.... select item from combobox, parameter cell changes, databasequery executes. Interestingly, the first time I select a particular combobox item, the database query executes. If I later select the same item, the query does not execute.

I also find that if I enter a value manually in the parameter cell the query executes. There appears to be a bug when using a combobox to populate the parameter cell for the query. Suggestions appreciated!

(I thought I could do this without VBA.... perhaps not)

 

[sunnyland]

Hello there,

The combo changing value will not trigger the the worksheet_change event.

2 ways I can think off. I suppose the linked cell of the combo is B1

Try to force the worksheet_change to happen

Private Sub ComboBox1_Change()
Dim rangi As Range
Set rangi = Range("b1")
Worksheet_Change rangi
End Sub


The other option you can try is [change sheetname and query name to corresponding]

Private Sub ComboBox1_Change()
sheet1.querytables("myquery").refresh
End Sub

 

[fprzekop]

Thanks Francois, I suspected as much. Forcing the query refresh is the approach I'll take.
- Fred