COMBO BOX TEXT BLANKS OUT

[fsweb2002]

Hi there
I seem to be having a major problem with a query routine which consists of 4 combo boxes.
I select different options from the combo boxes, and then press SEARCH button, which runs an SQL to select and display the info.
Everything works fine HOWEVER it appears the combo box values BLANK OUT. They are actually there because when I highlight the combo box, you can see the length of the text, but it just doesn´t show.
It appears to happen when I run the query and there are not matching records.
If it does find some, it seems not blank out, but as soon as there are no matches, it happens. Note that this is not a sure thing, but I just noticed it...

I´ve seen some info in the forum about this, however I am unable to find it...

Your help is appreciated

 

[grnzbra]

Try creating 4 variables. When you press the Search button, set each variable to the value of the .text property of its corresponding combo box. If no records are found, move the values from the variables back to the combo boxes.

 

[fsweb2002]

Hi there grnzbra

Sorry, that doesn´t work. I already tried doing that whether it finds a record or not, but still leaves the combo box blank.

Anyone has any ideas ?

I have tried the DB on 4 different computers (with different set ups, eg Windows 98, NT, etc) and all have the problem.

Isn´t there a bug problem described somewhere by Microsoft?

Anyone? Please, I am going nuts....