Requery ?

[dhstein]

I am creating a text box where the user will type in a string and then a
combo box will become visible. The combo box gets input from a query that
uses the string he has typed in. So far this works the first time. But the
second time it does not, so I need to requery something I think. The bottom
line is I want this query to rerun based on the new input when the combo box
becomes visible. Thanks for any ideas on this.

 

[BruceM]

Do you mean the combo box row source comes from a query that uses as a
criteria the information typed into the text box? If so, try requerying the
combo box in the text box After Update event. You could use a command
button or some other means if you prefer:

Me.ComboBoxName.Requery

 

[dhstein]

Bruce,
Thanks - that worked perfectly.

David

Do you mean the combo box row source comes from a query that uses as a
criteria the information typed into the text box? If so, try requerying the
combo box in the text box After Update event. You could use a command
button or some other means if you prefer:

Me.ComboBoxName.Requery