How to populate a Datacombo??

[Quique79]

Hi all!!

I have a form where depending on a value in a textbox, the Datacombo should be populated with a specific info.

I've tried with Onlostfocus event of the textbox, trying to put Datacombo's rowsource to the specific table, but it doesn't work

Any hint or tip? Quique79

 

[LittleSmudge]

Why use Lost Focus ?
Try AfterUpdate because you don't want to bother setting the Combo RowSource if the data in the txtBox has not changed.

Other than that ???
Sub txtBox_AfterUpdate()
cboBoxName.RowSource = "SELECT field1, field2 FROM tblName WHERE fldSelect = '" & txtBox & "'"
End Sub

Should do

If it doesn't, then what IS it doing?