Adding a new field to a Subform

A

Ann Shaw

Hi

I have created an Entry Form with a Subform underneath.
I now wish to add a Comment field to the Subform but keep
getting Name#!

I have gone back to the table and added the Comment field
in but cannot see it in the field list in the form??

What am I doing wrong???

Confused

Thanks

Ann (Ireland)
 
C

Cheryl Fischer

Ann,

Is the RecordSource of your subform based on a query? If so, you will need
to add that new field to the query.
 
A

Ann Shaw

Hi Cheryl
Thanks for your quick response. In answer to your
question, I don't have a query actually set up the subform
is coming from another table so there is no actual query
in place.
Does this make sense??

Ann
 
C

Cheryl Fischer

The only possibility that comes to mind is to make sure that you actually
added the Comment field to the table that is bound to the SubForm. Have you
tried opening that table to make sure that adding the new field to that
table was successful?
 
A

Ann Shaw

Hi Cheryl

I created the form again and the subform and it worked!
So, I reckon the field was not bound to the subform.

Thanks a million for your help!!

Kind regards

Ann
 
Top