Adding combo lookup field to form won't allow selection from list

[riggsd]

What do I need to look for when a lookup combo box field on a form will not let me select an item from the list? It beeps at me instead with no error message.

I can select items from the lookup listing just fine when it is in the table datasheet but as soon as I add it to the form, it won't let me select anything. The fields are enabled, not locked.

I have nine lookup combo fields in the table and only one of them allows me to select anything from the lookup listing once it is added to the form.

ETA: I also have a checkbox that works fine in the table but not on the form.

 

[alansidman]

Change your lookups to only be in the form and delete them from the tables. Read the following to learn why

The Access Web - The Evils of Lookup Fields in Tables

 

[riggsd]

How do you store the data in the field that you select from the form lookup?

 

[alansidman]

Bind your control (on the form) to the field in the table that you wish to hold the result of your lookup.

Look at this link. There are three tutorials on combo boxes.

DataPig Technologies Access Videos