Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I update the field list

Status
Not open for further replies.

aageorge

Technical User
Jun 28, 2003
51
US
I created a form using the wizard based on a table. I recently added a new field name to the table but I am unable to make it appear on the field list so that I can put it on the form. How can I solve this problem?
 
Look at the Recordsource of the form. Does it refer to your table or did it insert a Select ... clause instead? If Select clause, that's your problem.
 
Was the form open when you added the field to the table? If so, you may have to close the form and re-open it. Clicking the "field list" icon on the top tool bar should reflect everything that belongs in the source used for the form. Also, you may want to check on the record source your form is based off of. You may have selected a query to base your form off rather than a table. In this case, you would have to then add the field to the query as well...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top