Form's Caption

[m kappler]

I have a form with a subform. The subform displays
records in datasheet format but is not linked to
the main form.

I am attempting to get the hightlighted record on the
subform to appear in the main form's caption bar. If I isolate
the subform then that subform caption shows the current
record on the datasheet. I can't get it to work on the main
form however.

On the main form's current event I have
Me.Caption = Me.Subform.Form.EmployeeID
The main form caption only shows the first record on the
subform.

Can anyone help me on this. I have searched everywhere
Regards

 

[RuralGuy]

In the SubForm's Current event put:

Me.Parent.Caption = Me.EmployeeID

 

[m kappler]

Caption

Hi RuralGuy

Yes, that did it.
Thanks for that.
It looks so simple

 

[RuralGuy]

You're welcome. And Fred Astair made dancing look simple didn't he?