LookUp field on Form Not Displaying Data

[Richie2837]

I'm sure this is a rookie mistake, but I've not been able to figure it out.

I recently had to make an alteration to our contacts database to force the selection of one of five values from a drop-down list, as our users were inputting address data with incorrect spellings, or incorrect names which were causing errors when making calculations.

I changed the original field in the table from Text to a Look Up, and entered the five correct values which I wanted our users to choose from. This worked fine in the Table, but when I came to test it on the form, the drop-down field does not display the five values.

ANy idea what I've done wrong?

 

[neileg]

What you have done wrong is to apply a table level lookup. They never work well and sometimes screwup the whole deal.

Create a table to hold the valid values and then base a combobox on the table. Apply the combo to the relevant field in your form.

 

[Richie2837]

Thanks Neil,

I've done this and am able to select the relevant value from the combo box on the form, but it isn't saving the data back to the table?

Sometimes I feel like smacking my head with the palm of my hand and making a "d'oh!" sound!

 

[AccessNub]

what works for me with this issue is trashing the drop down off of the form and recreating it. not sure why, but it works

 

[neileg]

Thanks Neil,

I've done this and am able to select the relevant value from the combo box on the form, but it isn't saving the data back to the table?

Sometimes I feel like smacking my head with the palm of my hand and making a "d'oh!" sound!

Sounds like the control is not bound to the field. Make sure the Control Source property is set to your field name.