Hello!
im having a problem a with combobox.setfocus, this is the code that im running:
basicaly a simple filter on the combobox which works fine if recordcount > 0 on the current continuos form(pic1) but it wont work if there are no records(pic2)
The error says that it doesnt have the focus that's why i tried to force the Me.Combo0.SetFocus on every OnChange event but it doesnt work, Any ideas? :c
pic1
pic2
This is the normal combobox options
im having a problem a with combobox.setfocus, this is the code that im running:
Code:
Private Sub Combo0_Change()
Me.Combo0.SetFocus
Me.Combo0.RowSource = "SELECT taglio.[num taglio], taglio.[cod modello], taglio.Quantita, taglio.[data creazione] FROM taglio WHERE (((taglio.filtro) Like '*" & Me.Combo0.Text & "*')) ORDER BY taglio.[num taglio] DESC;"
Me.Combo0.Dropdown
End Sub
basicaly a simple filter on the combobox which works fine if recordcount > 0 on the current continuos form(pic1) but it wont work if there are no records(pic2)
The error says that it doesnt have the focus that's why i tried to force the Me.Combo0.SetFocus on every OnChange event but it doesnt work, Any ideas? :c
pic1
pic2
This is the normal combobox options
Last edited: