Linking Forms

[Stemdriller]

I have two bound forms both associated with separate tables. When a Check Box has been selected in Form 1 (frmPMSReq), I would like a button on Form 2 (frmContractHeader) to become visible when Form 2 is loaded.

I have tried - On Form Loaded
If [Forms]![frmPMSReq]![SelectionRequired] = True Then
cmdPMS.Visible = True

It would appear the issue is that frmContractheader cannot find frmPMSReq. Microsoft Access cannot find referenced form 'frmPMSReq'.

Any help please

Thanks
Gareth

 

[RuralGuy]

Is the frmPMSReq form still loaded?

 

[sly like Coyote]

Is the checkbox unbound? If not the requirement may really be related to the your data itself, and that may tip you off about whether or not you need to display the button instead of looking back at the other form.

If not I think you will only be able to refer to the other form while it's open.

 

[Stemdriller]

Thanks both for replying

I sorted it now, yesterday was not a good day for common sense for me.

DOH!

Gareth

 

[RuralGuy]

Thanks for posting back with your success.