new field does not appear in field list

[John Holland]

I must be missing something. After adding a new field (MEMO-type) in a
table, this field does not show up in the field list of a Form that i
have made. So i cannot make a source reference from a textbox in the
Form to the field name. Can someone help me out please? Thanks for
your kind assistance,
cheers,
JH

 

[SusanV]

Is the data source for the form a query rather than the table? If so, add
the field to the query.

 

[Jason Lepack]

I must be missing something. After adding a new field (MEMO-type) in a
table, this field does not show up in the field list of a Form that i
have made. So i cannot make a source reference from a textbox in the
Form to the field name. Can someone help me out please? Thanks for
your kind assistance,
cheers,
JH

Two options:

1) Close your form and re-open it
2) If above doesn't work then check your record source for your form.
If it's a query then make sure that said field is Selected.

Cheers,
Jason Lepack

 

[John Holland]

Two options:

1) Close your form and re-open it
2) If above doesn't work then check your record source for your form.
If it's a query then make sure that said field is Selected.

Cheers,
Jason Lepack

I have a relational database of just two tables and one form that
displays information from these two table through one key field that
appears in both table. After having added an additional field to one
of the tables, this new field does not show up in the field list when
i have the Form open. So after adding a textbox to the form i cannot
enter the specific field as control source for that textbox. I must be
missing something very simple here, any other clues?
thanks,
JH

 

[Jason Lepack]

I have a relational database of just two tables and one form that
displays information from these two table through one key field that
appears in both table. After having added an additional field to one
of the tables, this new field does not show up in the field list when
i have the Form open. So after adding a textbox to the form i cannot
enter the specific field as control source for that textbox. I must be
missing something very simple here, any other clues?
thanks,
JH- Hide quoted text -

- Show quoted text -

Open your form in Design Mode. Press Alt+Enter to bring up
properties. In the combo box select "Form". Click the "Data" tab.
What is in the "Record Source" field?

1) If it resembles "SELECT someField FROM ..." etc. then make sure
that your field is included in that statement.
2) If it's the name of a query then modify that query so that it
includes your field.
3) If it's the name of a table then it's probably not the table that
you added the field to...

 

[Douglas J. Steele]

I have a relational database of just two tables and one form that
displays information from these two table through one key field that
appears in both table. After having added an additional field to one
of the tables, this new field does not show up in the field list when
i have the Form open. So after adding a textbox to the form i cannot
enter the specific field as control source for that textbox. I must be
missing something very simple here, any other clues?
thanks,

As Jason's suggested in point 2, check the RecordSource property of your
form.

Open the form in Design mode, and make sure you've got the Form itself
selected, not a control on it. Look at the Properties dialog. RecordSource
should be the first entry on the Data tab (or on the All tab). There are 3
possibilities: it's going to be the name of the table in question, it's
going to be the name of a query, or it's going to be SQL. In the latter two
cases, click on the ellipsis (...) to the right of the property and make
sure the new field is included.

 

[John Holland]

Open your form in Design Mode. Press Alt+Enter to bring up
properties. In the combo box select "Form". Click the "Data" tab.
What is in the "Record Source" field?

1) If it resembles "SELECT someField FROM ..." etc. then make sure
that your field is included in that statement.
2) If it's the name of a query then modify that query so that it
includes your field.
3) If it's the name of a table then it's probably not the table that
you added the field to...- Hide quoted text -

- Show quoted text -

Ok,
i got it working, thanks. Still, it seems strange that the field does
not appear automatically in the field list, bug in Access?
cheers,
JH

 

[Jason Lepack]

So what did you do to get it working?

Ok,
i got it working, thanks. Still, it seems strange that the field does
not appear automatically in the field list, bug in Access?
cheers,
JH- Hide quoted text -

- Show quoted text -

 

[John Holland]

So what did you do to get it working?





- Show quoted text -

I followed your suggestion : "Press Alt+Enter to bring up
properties. In the combo box select "Form". Click the "Data" tab.
What is in the "Record Source" field?

1) If it resembles "SELECT someField FROM ..." etc. then make sure
that your field is included in that statement. "

after being there, i entered the fieldname manually in the same format
as the other fieldnames appeared. That worked well. After that the
particular field also appeared in the field list of the form and i
could make the source reference for the textbox. This sort of detour
although it worked, still seems strange to me, what do you think?
cheers,
JH

 

[Jason Lepack]

I followed your suggestion : "Press Alt+Enter to bring up
properties. In the combo box select "Form". Click the "Data" tab.
What is in the "Record Source" field?

1) If it resembles "SELECT someField FROM ..." etc. then make sure
that your field is included in that statement. "

after being there, i entered the fieldname manually in the same format
as the other fieldnames appeared. That worked well. After that the
particular field also appeared in the field list of the form and i
could make the source reference for the textbox. This sort of detour
although it worked, still seems strange to me, what do you think?
cheers,
JH- Hide quoted text -

- Show quoted text -

No it doesn't seem strange to me at all. Your form was told that it
would only receive data from the specific fields that were listed in
that statement. Therfore when you added a new field (or 100 new
fields for that matter) the form would still only look at the fields
that it was told to look at.

The idea is that you should understand what your data is going to be
and develop a table structure to hold that data before you start
making forms. That way, you don't have to go back and find these
niggling little bits.

Cheers,
Jason Lepack

 

[Joan Wild]

I followed your suggestion : "Press Alt+Enter to bring up
properties. In the combo box select "Form". Click the "Data" tab.
What is in the "Record Source" field?

1) If it resembles "SELECT someField FROM ..." etc. then make sure
that your field is included in that statement. "

after being there, i entered the fieldname manually in the same format
as the other fieldnames appeared. That worked well. After that the
particular field also appeared in the field list of the form and i
could make the source reference for the textbox. This sort of detour
although it worked, still seems strange to me, what do you think?
cheers,

For future reference, you could have hit the build button (...) to the right
of that statement and it would have brought up the query design grid where
you could have added your field more easily.

Also, since your recordsource was a SQL statement, adding field(s) to the
underlying tables doesn't mean they'll automatically get added to your SQL
statement. There are only two ways the added field would appear
automatically:

If the recordsource was set to your table.
If the recordsource was a SQL statement with SELECT * FROM YourTable...

 

[John Holland]

For future reference, you could have hit the build button (...) to the right
of that statement and it would have brought up the query design grid where
you could have added your field more easily.

Also, since your recordsource was a SQL statement, adding field(s) to the
underlying tables doesn't mean they'll automatically get added to your SQL
statement. There are only two ways the added field would appear
automatically:

If the recordsource was set to your table.
If the recordsource was a SQL statement with SELECT * FROM YourTable...

Thanks for all your kind help. This was an eye-opener.
cheers,
JH

 

[John Holland]

For future reference, you could have hit the build button (...) to the right
of that statement and it would have brought up the query design grid where
you could have added your field more easily.

Also, since your recordsource was a SQL statement, adding field(s) to the
underlying tables doesn't mean they'll automatically get added to your SQL
statement. There are only two ways the added field would appear
automatically:

If the recordsource was set to your table.
If the recordsource was a SQL statement with SELECT * FROM YourTable...

Ok Joan, thanks, that build button is helpful, did not know that,
cheers,
JH