Adding more fields

I have added more fields to a table that I already have a form
designed for. I would like to add those fields to the form but they
don't appear in the list.

How can I add them to the form without having to redo the whole thing?

On Fri, 01 Dec 2006 19:31:39 -0500, Mary Hartman
wrote:



I have added more fields to a table that I already have a form
designed for. I would like to add those fields to the form but they
don't appear in the list.

How can I add them to the form without having to redo the whole thing?


I have tried a number of ways and keep getting "?NAME" in the control
box when the form is open. It also won't allow me to either remove
that or add anything.

Sure. First check and see if your form is based directly on the table, or
(more likely) if it's based on a query. If it's a query, open it in design
view and add the fields. Then you should be able to see them in the field
list.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Mary Hartman" wrote in message
...


I have added more fields to a table that I already have a form
designed for. I would like to add those fields to the form but they
don't appear in the list.

How can I add them to the form without having to redo the whole thing?

On Fri, 1 Dec 2006 19:50:06 -0500, "Arvin Meyer [MVP]"
wrote:

Sure. First check and see if your form is based directly on the table, or
(more likely) if it's based on a query. If it's a query, open it in design
view and add the fields. Then you should be able to see them in the field
list.


My form is based directly on the table.

"Mary Hartman" wrote in message
...
On Fri, 1 Dec 2006 19:50:06 -0500, "Arvin Meyer [MVP]"
wrote:

Sure. First check and see if your form is based directly on the table, or
(more likely) if it's based on a query. If it's a query, open it in design
view and add the fields. Then you should be able to see them in the field
list.

My form is based directly on the table.

You should be able to see them then. Only queries can hide them if they are
not in the underlying query. Just a WAG, are the new fields lookup fields?
You should be able to see them, but occasionally you don't see them
correctly.Try expanding the field list and see if they are indeed there.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I don't know why i having trouble with this. I am really not this
stupid.

Let me give a step by step what I did, maybe you can find my mistake.

I have a table products. To fill in the table products I have a form
products_input.

When I created the form, I created it directly from the table with the
wizard. I just selected all fields.

Now I have added 6 fields to the table. I am trying to create a
controsl in the form for them.

I insert a text box.

I right clicked on the text box and select properties.

In the data tab, I clicked the" ..."

I click the tables folder to expand it.

I click the table products folder so that all the fields appear in the
center column

I click on the field I want.

Now I have this on the form in design view inside the text box.


=products!products_image_1_text


When I go to regular view, I have this in the box.

#Name?

And it won't do anything. What have I done wrong?

Mary






On Fri, 1 Dec 2006 20:16:59 -0500, "Arvin Meyer [MVP]"
wrote:

"Mary Hartman" wrote in message
.. .
On Fri, 1 Dec 2006 19:50:06 -0500, "Arvin Meyer [MVP]"
wrote:

Sure. First check and see if your form is based directly on the table, or
(more likely) if it's based on a query. If it's a query, open it in design
view and add the fields. Then you should be able to see them in the field
list.

My form is based directly on the table.

You should be able to see them then. Only queries can hide them if they are
not in the underlying query. Just a WAG, are the new fields lookup fields?
You should be able to see them, but occasionally you don't see them
correctly.Try expanding the field list and see if they are indeed there.

It has no idea what:

=products!products_image_1_text

is. If the name of the field is: products_image_1_text, just select that
from the list in the Control Source drop down on the property sheet.
Alternatively, open the field list and drag the new field to you form.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Mary Hartman" wrote in message
...

I don't know why i having trouble with this. I am really not this
stupid.

Let me give a step by step what I did, maybe you can find my mistake.

I have a table products. To fill in the table products I have a form
products_input.

When I created the form, I created it directly from the table with the
wizard. I just selected all fields.

Now I have added 6 fields to the table. I am trying to create a
controsl in the form for them.

I insert a text box.

I right clicked on the text box and select properties.

In the data tab, I clicked the" ..."

I click the tables folder to expand it.

I click the table products folder so that all the fields appear in the
center column

I click on the field I want.

Now I have this on the form in design view inside the text box.


=products!products_image_1_text


When I go to regular view, I have this in the box.

#Name?

And it won't do anything. What have I done wrong?

Mary






On Fri, 1 Dec 2006 20:16:59 -0500, "Arvin Meyer [MVP]"
wrote:

"Mary Hartman" wrote in message
. ..
On Fri, 1 Dec 2006 19:50:06 -0500, "Arvin Meyer [MVP]"
wrote:

Sure. First check and see if your form is based directly on the table,
or
(more likely) if it's based on a query. If it's a query, open it in
design
view and add the fields. Then you should be able to see them in the
field
list.

My form is based directly on the table.

You should be able to see them then. Only queries can hide them if they
are
not in the underlying query. Just a WAG, are the new fields lookup fields?
You should be able to see them, but occasionally you don't see them
correctly.Try expanding the field list and see if they are indeed there.

Hi Arvin,

Thank you for keep coming back to me.

These 6 new fields that I added to the table appear neither in the
drop down of the data control on the properties panel, nor do they
appear on the available field list.

Is there maybe a bug that I need a fix for?

I mean besides for myself... bugging you I mean.

That was supposed to be a joke.

Mary




On Fri, 1 Dec 2006 20:50:02 -0500, "Arvin Meyer [MVP]"
wrote:

It has no idea what:

=products!products_image_1_text

is. If the name of the field is: products_image_1_text, just select that
from the list in the Control Source drop down on the property sheet.
Alternatively, open the field list and drag the new field to you form.

if you're using A2000 or newer, did you turn OFF the Name Autocorrect option
when you created your database? if not, suggest you do the following:

create a new, blank database.
immediately turn OFF Name Autocorrect via Tools | Options | General tab on
the menu bar.
compact the database.
import all the objects from your current database into the new database, and
compact it again.

now take a look at the field list in the form's Design view. can you see all
the fields? if not, look at the RecordSource property in the Properties box.
does it show the table name that you expect to see? or does it show a SQL
statement, that starts with "SELECT..."? if the latter, click the Build
(...) button at the right side of the property line, and add the new fields
to the design grid.

hth


"Mary Hartman" wrote in message
...
Hi Arvin,

Thank you for keep coming back to me.

These 6 new fields that I added to the table appear neither in the
drop down of the data control on the properties panel, nor do they
appear on the available field list.

Is there maybe a bug that I need a fix for?

I mean besides for myself... bugging you I mean.

That was supposed to be a joke.

Mary




On Fri, 1 Dec 2006 20:50:02 -0500, "Arvin Meyer [MVP]"
wrote:

It has no idea what:

=products!products_image_1_text

is. If the name of the field is: products_image_1_text, just select that
from the list in the Control Source drop down on the property sheet.
Alternatively, open the field list and drag the new field to you form.

THANK YOU!!

That did it exactly!!!!!


Mary


On Sat, 02 Dec 2006 03:00:27 GMT, "tina" wrote:

if you're using A2000 or newer, did you turn OFF the Name Autocorrect option
when you created your database? if not, suggest you do the following:

create a new, blank database.
immediately turn OFF Name Autocorrect via Tools | Options | General tab on
the menu bar.
compact the database.
import all the objects from your current database into the new database, and
compact it again.

now take a look at the field list in the form's Design view. can you see all
the fields? if not, look at the RecordSource property in the Properties box.
does it show the table name that you expect to see? or does it show a SQL
statement, that starts with "SELECT..."? if the latter, click the Build
(...) button at the right side of the property line, and add the new fields
to the design grid.

hth


"Mary Hartman" wrote in message
.. .
Hi Arvin,

Thank you for keep coming back to me.

These 6 new fields that I added to the table appear neither in the
drop down of the data control on the properties panel, nor do they
appear on the available field list.

Is there maybe a bug that I need a fix for?

I mean besides for myself... bugging you I mean.

That was supposed to be a joke.

Mary




On Fri, 1 Dec 2006 20:50:02 -0500, "Arvin Meyer [MVP]"
wrote:

It has no idea what:

=products!products_image_1_text

is. If the name of the field is: products_image_1_text, just select that
from the list in the Control Source drop down on the property sheet.
Alternatively, open the field list and drag the new field to you form.