Adding a field from another table on a form

I'm trying to add a field to my master form from another table. I created a
relationship between the master table and the other table, but even after
I've updated the control source to = [table]![field] all of the results are
showing as "#Name?" .

I know I'm doing something silly, please help me.

To add a field it needs to be in the report's Record Source. Use a query
rather than a table. However, a query based on related tables may not be
updatable. You have provided few details, so it is difficult to be specific,
but typically a subform is used to add/display/edit related records.
The problem (or one of the problems at least) with your attempted Control
Source is that it does not specify a record. Since the field is not in the
form's Record Source there is no way for Acces to know which record you want
to display.

FergusonH wrote:
I'm trying to add a field to my master form from another table. I created a
relationship between the master table and the other table, but even after
I've updated the control source to = [table]![field] all of the results are
showing as "#Name?" .

I know I'm doing something silly, please help me.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200912/1

That was supposed to be "To add a field it needs to be in the form's Record
Source". The statement would apply to reports, but that's not what you are
asking about.

FergusonH wrote:
I'm trying to add a field to my master form from another table. I created a
relationship between the master table and the other table, but even after
I've updated the control source to = [table]![field] all of the results are
showing as "#Name?" .

I know I'm doing something silly, please help me.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200912/1