drop down box in form

[askjacq]

I have 2 tables, tContacts and tOrgs. I set the org field in the tContacts to look up the org field in the tOrgs. When I put the org field from tContacts in the form, it won't show up as a drop-down list. When I make it a combo box, the orgs from the tOrgs table don't appear

[askjacq]

Additional info: it works if I use a table for the form data, but not if I use a query.

[alansidman]

On this site are three tutorials on Combo Boxes -- Scroll down to them and see what Mike did that you didn't.

http://www.datapigtechnologies.com/AccessMain.htm

Alan

[jzwp11]

Welcome to the forum!

Although Access has the capability of creating lookup fields at the table level. It is generally not recommended. This site tell why.

I would change the org field in your contacts table to a number field (long number datatype) assuming that the primary key field of the org table is an autonumber datatype. Then just use the combo box wizard in your contact form to pull the data from the org table.

[delacra]

Hi,
1) you need create a table tContatcs fields contactID PK, ContactName, Org
2) Create a tOrgs with fields: OrgsID PK, OrgsName field, save and close tables
3) Open table tContact and in field Org set it as Lookup Wizard and select tOrgs as source...Follow wizard instruction (first optio)...after that save the table and try it... it should be working now...

Let's me know if this worked for you....

[askjacq]

Please don't give me table design issues - there's a reason why I designed it this way. i just want to figure out why to get a lookup to be a drop down box in a form when using a query as the data source.

[askjacq]

this doesn't address using queries as the data source

[askjacq]

By the way, this worked in Office 2003 - just not Office 2010.

[jzwp11]

When I make it a combo box, the orgs from the tOrgs table don't appear

Does the row source of the combo box show the applicable table/query you wanted?

Are the column widths property set to non-zero values?

[alansidman]

Perhaps it is time for you to post a copy of your database. We are guessing and not hitting the bullseye. Time to see the issues so that we can hit the target.

Alan