I have created a combo box on a form and want it to look up values on the form based upon the combo box results that is based upon a different query (same field name). Once I’ve created the combo box based upon linking it to the query I want to use, the drop down box when clicked in the form view is blank. I also tried to create a combo box on the form based upon the same field that is underlying the form (query) and still it generates a blank drop down when clicked. However, if I type the info into the blank combo box it generates the desired results. The combo box is not “seeing” the input info.
Is there a combo setting or a form setting that is incorrect? This never was a problem before.
I’m looking for a non-code solution, i.e., using Access objects.
Thanks for any help. EqInc