Update value in combo box

[Jacek T via AccessMonster.com]

Hi,
I have a simple form with the combo box that looks for the records based on
the selected value. It does it very well except......when I click the "Next"
button, value in the combo box remains the same, even though record changes.
How can I have my combo updating value along with the changing record. Or.....
..how can I assign fixed value to the combo that would be shown every time
when combo IS NOT dropped down??? Example of such fixed value: string: "---
Select Item ---". Anybody, any ideas????

 

[tina]

using an unbound combo box to find specific records on a form is a common
solution. i usually set the value of the combo box to Null at the end of the
macro or code that finds the record. that way it's always blank and "ready"
for a user to do a search, and i don't have to worry about maintaining a
synchronized value in it.

hth