Howdy,
This has been driving me nuts.
What I have attempted to do is create a selection form. The header has three Combos ,Each Combo gets it's list from a select for the specific field in the forms base query. Any combination of combo values can be included in the final query which when completed I assign to the forms record source. This gives me my result set no problem. I can submit any valid combination and get the correct result set.
Now the odd thing, if I pursposefully pick a combination of values that do NOT have a valid result in the base query. The nextime I try select a value From the drop downs they go blank. The drop down shows the underlying option list but when selected the selected text does not appear in the Combo field.
I set a msgbox equal to the value of each combo to see if anything was being passed in code and the value is displayed in the msgbox. What is going on?
I close the form and start over, all is well until I pick a criteria with no result set.
Help.
This has been driving me nuts.
What I have attempted to do is create a selection form. The header has three Combos ,Each Combo gets it's list from a select for the specific field in the forms base query. Any combination of combo values can be included in the final query which when completed I assign to the forms record source. This gives me my result set no problem. I can submit any valid combination and get the correct result set.
Now the odd thing, if I pursposefully pick a combination of values that do NOT have a valid result in the base query. The nextime I try select a value From the drop downs they go blank. The drop down shows the underlying option list but when selected the selected text does not appear in the Combo field.
I set a msgbox equal to the value of each combo to see if anything was being passed in code and the value is displayed in the msgbox. What is going on?
I close the form and start over, all is well until I pick a criteria with no result set.
Help.
