Can't seem to bind a form control to a field not in the field list

[Guest]

Good day,

I am experiencing some difficulty in getting a field on a tab form to bind
to a field in a table.

I am working on a tab form that has 5 tabs on it. Each tab is supposed to
pull data from a different table. Most of them seem to be working ok, but on
a specific form, I can't get the control on the form to show the data from
the table. I tried clicking on the field, then going to the properties and
selecting the builder in the control source, then browsing to the table and
field I want it to link to, but then I get a cautiounary icon saying invalid
control source. I also tried making a form of this one field and then copying
and pasting that onto the tab form, but when I go to view them form, all I
see is "?Name". What am I doing wrong? Please advise.

Thanks for your assistance,

 

[John Vinson]

Good day,

I am experiencing some difficulty in getting a field on a tab form to bind
to a field in a table.

I am working on a tab form that has 5 tabs on it. Each tab is supposed to
pull data from a different table.

Tabs don't work that way. They have NOTHING to do with tables or the
logical ordering of the data. Tab controls are *only* a way of
managing screen space; the controls on a Tab Control are simply
controls on the form, based on the Form's Recordsource. Since a Form
can only have one Recordsource, you'll probably need to put a Subform
control on each tab page to get the effect you want.

Most of them seem to be working ok, but on
a specific form, I can't get the control on the form to show the data from
the table. I tried clicking on the field, then going to the properties and
selecting the builder in the control source, then browsing to the table and
field I want it to link to, but then I get a cautiounary icon saying invalid
control source.

That's because the ONLY fields that you have accessible are those
fields in the Form's Recordsource (which might be a Table or a Query).

Don't try making a five-table join for the Query and using it as the
recordsource though - even if the query were updateable (not likely)
you'ld have confusing missing or duplicated records because of the
joins.

I also tried making a form of this one field and then copying
and pasting that onto the tab form, but when I go to view them form, all I
see is "?Name". What am I doing wrong? Please advise.

You're just assuming more power for the Tab Control than it possesses!

John W. Vinson[MVP]

 

[Guest]

John,

Thanks for all the good info. I didn't realize some of the limitations to
the tabs and forms in access. I appreciate your assistance.