Adding New Fields to an existing form

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

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.

"Sarah Hill" wrote in message
...
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

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.

"Sarah Hill" wrote in message
...
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


.

Is the table a linked table? If so, you need to refresh the link
(ToolsDatabase UtilitiesLinked 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.

wrote in message
...
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.

"Sarah Hill" wrote in message
...
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


.