Adding a new field to a Subform

[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)

 

[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.

 

[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

 

[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?

 

[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