can't display same field in a subform

[jackinoz]

Help

In a very simple form within a small database, I want to display a field "ServiceChargeStart" from main form "ApplicantDetails" on a subform "ElectricitySafetyChecks" in a field called "DateLastElecCheck

I think I should be able to do this by using " =[ApplicantDetails]![ServiceChargeStart] " in the control source of "DateLastElecCheck", but this doesn't seem to work. Ihave tried various similar variations

Any Suggestions?

Yours hopefully

Jackinoz

 

[Wayne Morgan]

Try
=[Parent]![ServiceChargeStart]

I tried this and it worked; however, it didn't appear to auto-update. To
take care of this you will need to place

Me.NameOfSubformControl.Form.Recalc

in the main form's Current event and the main form control's AfterUpdate
event.

--
Wayne Morgan
Microsoft Access MVP

Help!

In a very simple form within a small database, I want to display a field

"ServiceChargeStart" from main form "ApplicantDetails" on a subform
"ElectricitySafetyChecks" in a field called "DateLastElecCheck"

I think I should be able to do this by using "

=[ApplicantDetails]![ServiceChargeStart] " in the control source of
"DateLastElecCheck", but this doesn't seem to work. Ihave tried various
similar variations.

 

[jackinoz]

Ta much Wayne,

Worked a treat!

Jackinoz