Newly added field in a Table doesn't show up in choices for a ComboBox

[Guest_imported]

I added a new field to one of my tables which was already bound to a form. When I try to modify this form and add a new combo box whose value is supposed to be stored in this new field, the field name i just added doesn't show up in the options, but all the older fields which were present in the table when the form was designed show up.
Is there any way to make the form recognize the newly added field? I tried to get out of the database completely and logged in again, but it didn't help.
And btw, I'm using the ComboBox wizard.
Thanks!
Desi

 

[gwinn7]

Try this...

Check the Recordsource property of the form. You could be using a query to access the table. If you are, instead of referencing the table directly, then you may need to adjust the query to include that field (unless of course you are using (SELECT *). The form only knows about the fields you tell it to use (to state the obvious!).

That is the first thing I would look at. I hope it helps.

Gary
gwinn7

 

[dzdncnfsd]

You may also have to relink the table to the database. Structure changes are not automatically recognized.
Gladys

Gladys Clemmer
gladys.clemmer@fifsg.com

 

[Guest_imported]

Thanks for your help, Gary! It worked after I adjusted the query.

 

[gwinn7]

You are welcome!!!

To Gladys,

I have never had to re-link a table in my Access app for table structural changes to show up. Are you referring to a unique situation perhaps? Please clarify.

Thanks,
Gary
gwinn7