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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access-Cannot update Field List on Form Design

Status
Not open for further replies.

Evelyn

Technical User
Apr 17, 2000
4
US
from my table I made a form using the field list.&nbsp;&nbsp;then I made changes to my table and added fields.&nbsp;&nbsp;i cannot get the new fields on the field list on the forms.&nbsp;&nbsp;online help suggests right clicking on the DB icon and request refresh.&nbsp;&nbsp;in the form design field list it does not allow me to right click.<br><br>(i did not use a query to generate my form)<br><br>Can you please help???&nbsp;&nbsp;thank you.
 
Why they don't show up in the field list anymore?<br>Or are you getting an Error<br><br>Do this:<br>Open your form in design view.<br>Then Look at the properties of the form.<br>It will have a huge list of stuff.<br>At the very Top is the &quot;record source&quot;<br>Is it the exact spelling of your table?<br>Or does it start with &quot;SELECT ......<br>If it starts with &quot;select&quot; then click the down arrow key and find your table so it just shows your table name.<br>Then you will be able to add your new fields.<br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top