cant find field listed in control source

[Bruce Skamser]

I added a field to a table and when I go to the form to add a textbox
control, I can't bind it to the field in the table. It doesn't come up in
the list of fields in the control source dropdown. What can I be doing
wrong?

[Ken Snell]

If the form's RecordSource is a query, you'll need to add that field to the
query too.

--

Ken Snell
<MS ACCESS MVP>

"Bruce Skamser" <sk*****@sbcglobal.netwrote in message
news:CG*******************@newssvr13.news.prodigy. net...

>I added a field to a table and when I go to the form to add a textbox
control, I can't bind it to the field in the table. It doesn't come up in
the list of fields in the control source dropdown. What can I be doing
wrong?

[Larry Linson]

"Ken Snell" <kt***********@ncoomcastt.renaetlwrote

If the form's RecordSource is a query, you'll need
to add that field to the query too.

And, worth saying, sometimes Access and its wizards will create an SQL
statement from the table you intended to use, particularly if you click the
button to view the RecordSource in Query Builder. If you don't remember
that you've done that, it may be puzzling that your table has "turned into"
a query.

Larry Linson
Microsoft Access MVP

[Lyle Fairfield]

Bruce Skamser wrote:

I added a field to a table and when I go to the form to add a textbox
control, I can't bind it to the field in the table. It doesn't come up in
the list of fields in the control source dropdown. What can I be doing
wrong?

I think you are doing nothing wrong.
When you save a form with a record source the recordsource's fields, in
this case the table's fields, are saved in the form's type info.
If you modify the table the form has no way of knowing this. It
"thinks" the fields are the original fields from the original save.
A solution is to remove the recordsource and to save the form, and then
to re-specify the recordsource and save the form. (The double save may
be unnecessary; you could test.) Now all the recordsource's fields
should be in the form's type info and available with IntelliSense (the
dot).
(I did not discover this information myself; Michael Kaplan explained
it years ago).

[tina]

for two possible solutions, see
http://groups.google.com/group/micro...13428b83206c35

hth
"Bruce Skamser" <sk*****@sbcglobal.netwrote in message
news:CG*******************@newssvr13.news.prodigy. net...

I added a field to a table and when I go to the form to add a textbox
control, I can't bind it to the field in the table. It doesn't come up in
the list of fields in the control source dropdown. What can I be doing
wrong?