Look up field in table not coming up as look up in form

[Margarita]

Hello, I have a table, Transactions, in which one of the fields is a look up field, looking up values from another table. I created a form based on Transactions and I want all new records to be added using this form. However, the field in question is NOT coming up on the form with a drop down menu. The user has to type in the values. How can I re-create the field as a look up in the form, but retain the values which have already been entered into the table?
Thank you.

 

[jdraw]

Please show us a jpg of the form, and the rowsource of the combo box.

 

[Margarita]

Hello, the field is not a combobox. The form was created directly from the table using the wizard, so the source of the field is the corresponding field in the table. I want to have the user do additions and edits in this form preferably without having to write vba on the back end, so that's why i want to fields on the form to be directly linked to the fields in the table. Shouldn't a look up field in a table be automatically created with a drop down menu in the form?
Thank you.

 

[boblarson]

Lookups should not be used at table level, unless you are very experienced and know the pitfalls. Use them at form level but not at table level. Remove the lookup from the table and set them using combo's on forms.

See here for more about this:
http://www.mvps.org/access/lookupfields.htm

 

[Margarita]

Lookups should not be used at table level, unless you are very experienced and know the pitfalls. Use them at form level but not at table level. Remove the lookup from the table and set them using combo's on forms.

See here for more about this:
http://www.mvps.org/access/lookupfields.htm

I am convinced! I will remove the look up from the table. It's just that it's so convenient in the short term...
Thank you!

 

[boblarson]

It's just that it's so convenient in the short term...

It is fine to use it temporarily as it helps set up your combo's on your forms but once you have those created, delete it from the table. And, just in case you weren't sure how -
http://www.btabdevelopment.com/ts/removelookups

 

[Margarita]

It is fine to use it temporarily as it helps set up your combo's on your forms but once you have those created, delete it from the table. And, just in case you weren't sure how -
http://www.btabdevelopment.com/ts/removelookups

Thank you, Bob! I actually did NOT know how to remove the lookup. This was very helpful.