Adding a new Field?

[jdupaix]

I am using Access 2003 and I have what I believe to be a simple question. In my data base I have Form A. The fields that that I use come from Table A. I added 2 fields in Table A and they show up like I would expect in Table A.

The problem then comes when on Form A I try to add these fields to my form. I click on the Field List icon and open it, It shows all of the fields from when I started the project but my 2 new fields are not an option. How do I get them to show up on my Field List so I can use them?

Thanks
Joe

 

[llkhoutx]

You probably added the fields to the table while the form was open in view or design mode.

Close the form and then re-open it. The added fields should then appear in the form's field list.

 

[llkhoutx]

You probably added the fields to the table while the form was open in view or design mode.

Close the form and then re-open it. The added fields should then appear in the form's field list.

You've probably already found this method.

 

[jdupaix]

I have tried that with no success.

 

[georgedwilkinson]

Refresh your links.

 

[jdupaix]

Will you tell me how to do that?

 

[georgedwilkinson]

My assumption is that you have your data in a separate back end and that you have links in your front end that point to those.

On your tables screen on the front end database, right click on any linked table and select "Linked table manager". Select the table whose fields are not showing and click "OK".

If you are not using linked tables, this will not help. BTW, you should be using linked tables unless you have a single user database.