combo box values dissapear whe doing query

[fsweb2002]

HI there
I have asked this question before without an answer. I am hoping someone has an xplanation now...

I have a form with 4 combo boxes and a SEARCH button.

When I click the search button it runs an SQL which uses the values on the combo boxes.
All works fine EXCEPT that the value on the combo boxes dissapear every now and then.
It happens when I do a search and no records show (because the query doesn´t return any records).
The values are there (I can highlight the value and can see its length, but it is just a dark highlight.

Anyone found out how to fix this problem ?
I know there were other people having the same problem...

Thanks in advance

 

[Darrylles]

Hiya,

Sounds like you are selecting values in the combos, then doing a 'search' based on their values.

If the search results in no records being returned, then the combos will NOT have a value - the record is empty.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[fsweb2002]

thanks for your reply.
Sorry, I didn´t explain myself correctly.
If I select the correct values and a matching record(s) is found, the information displays perfectly.
So the SQL and combo boxes work fine.
HOWEVER; it is when there are no records found that the value on the combo boxes dissapear.

Anybody ?