Changes in the subform 1

[pooterpooter]

In the table underlying the subform i have added a name to the caption.Now when i make a query the field appears with the name of the caption.However, in the subform, this change appears not to be refllected.
The field appears with its original name and not with the caption i have entered for this field.I open the subform from the main form, and the subform is in a datasheet format.
What shall i do in order to change the name of the field in the subform to be the caption name ?

 

[PHV]

Suppress and recreate the RecordSource property of the subform.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886