Combo box in forms not working

[Tazmaniac]

Hi all!

I am new to access and need some help.

I have created a query for a lookup I am using in a table.
In the table itself I am able to select from the dropdow and store the value but when I add the field to my table the lookup values shows but it does not want to select anything to store.



I have checked and my combo box does allow edits.

What else am I missing?

Thank you in advance!

[June7]

I never build lookups in table.

What do you mean the combobox allows edits? If it allows edits then should be able to select from dropdown.

Really would have to review table structures and form design. If you want to provide db for analysis, follow instructions at bottom of my post.

[orange]

What else am I missing?

Perhaps this, but I'm not exactly certain of your setup.

[Tazmaniac]

Thank you for the reply. I will have a look at it.

What I did was create a table where my lookup values lie. I then created a lookup field in my main table and linked it to the table with the lookup values in.

When I enter data in the table itselfs the combo box works perfect and I am able to select a value from the dropdown. When I add the field to my form and click on the combo box the values show but I cannot select any of them. Nothing happens.

What do you mean you never build lookups in a table? Why not if I may ask? What is the best way to do this?

[moke123]

What do you mean you never build lookups in a table? Why not if I may ask? What is the best way to do this?

If you read the link Orange provided or googled lookup fields you'd find that they often mask what is being saved in the table and
are a source of a lot of problems with new developers.

In your table change the field back to a normal datatype. On your form put your combobox and set the control source to the field in your table. Then set the rowsource of the combobox to the lookup table.

[Tazmaniac]

So just to check if I understand this correct (being new to developing access databases and all) ...

Instead of ...

Going to the design view of my table and changing the data type of the field to "Lookup Wizzard..." and must instead ...

Leave the field on normal text field and in the form insert a combo box and then link it to the table?

[orange]

Tazmaniac,

You might get more context regarding lookup fields and Lookup tables from this thread where the author had similar question/concerns as you.