By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,742 Members | 1,227 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,742 IT Pros & Developers. It's quick & easy.

cant find field listed in control source

P: n/a
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?
Dec 3 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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?

Dec 3 '06 #2

P: n/a
"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
Dec 3 '06 #3

P: n/a
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).

Dec 3 '06 #4

P: n/a
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?


Dec 3 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.