Question Locked

Combo Box Drop Down List Will not Display in Access 2003

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by absolutely

I was not able to re-create the problem, but I tried Google and found "This is probably due to a known bug in Access XP Service Pack 3.
tblEquipment.txtEquipNumber has a format property in the table. The
employee field does not.
Quick fix, change the row source on the combobox to
SELECT tblEquipment.txtEquipNumber & "" AS txtEquipNumber.... "

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access&tid=9144ce91-0d86-4474-8c9f-f72d8280038e&p=1

by jhadams

I thought when I found this that I would be able to fix the access database we operate. I must be doing something wrong.
My Table name = tbl-Customer, my Field name = CustomerCode
I put in row source on the combo box the following
SELECT tbl-Customer.CustomerCode &"" AS CustomerCode.... "

I received the following error
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

Any ideas

This discussion is closed to new replies.