Adding New Fields to an existing form

[Sarah Hill]

I'm using ACCESS 2000 and have set up a form which is now
in use. I'd now like to update my form with some extra new
fields which I have added to the table. However they do
not appear in the field list and there is no option to
import them. Can anyone help???

Thanks in advance

Sarah

 

[Kevin3NF]

Is the form based on the table, or on a query which is based on the table.
If a query, then you need to add the fields to the query first, and then
they will appear in the field list.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Guest]

Hi It's based on a table.

-----Original Message-----
Is the form based on the table, or on a query which is based on the table.
If a query, then you need to add the fields to the query first, and then
they will appear in the field list.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.




.

 

[Kevin3NF]

Is the table a linked table? If so, you need to refresh the link
(Tools>>Database Utilities>>Linked Table manager)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.