Combobox shows up in query and table, but not in form!

[mfearer94]

I'm almost done with my db and then I remembered that I forgot to turn one of my text fields into a combo box.

So I went into the table and turned the field into a combo box using a value list with a bunch of values that I input.
Then I went to the query thinking that the information would be updated, but it wasn't.
So, I input the same information in that field for the query as I did for the table.
Then I went to the form and I click and its just a plain text box with no drop down menu or anything.



The table and query both have the drop down feature with the values that I input.
The form is based off of the query and all of the other fields work.
Please help so I can finish this and thanks in advance.

[ssanfu]

I'm almost done with my db and then I remembered that I forgot to turn one of my text fields into a combo box.

This is considered a bad thing to do..... and a big waste of time (IMO).

I have never used "Lookup FIELDS". No experienced Access programmer I know of uses "Lookup FIELDS".

"Lookup FIELDS" are marginally helpful if the dB is only for your use and you use tables/queries to enter/edit the data.
If the dB is used by other people, you need to use forms for adds/edits. A used should never directly edit a table/query.
Using a form, you still have to create a combo box, even if the bound field is a "Lookup FIELD".

See The Evils of Lookup Fields in Tables
http://access.mvps.org/access/lookupfields.htm

Best thing you can do is remove all "Lookup FIELDS" from your tables and create proper combo boxes.


My $0.02

[June7]

Control created on form before table edit will not automatically be modified.

I agree with Steve, I never set lookups in tables.

[mfearer94]

Wow, thanks guys for the help. I now see the evil of lookup fields, but are there any pros to using lookup fields instead of combo boxes?

[June7]

Lookups themselves are not evil, it is using them in tables that is.

A combobox IS a lookup. We are just recommending you don't set in table.

I've never used the Lookup Wizard. I avoid the wizards in general.

[mfearer94]

Gotcha and thanks for the help. You guys saved me a lot of future headaches.