Event Procedure for on load event for Form

[Jgk]

I am using Denis Wright's Permission VBA code and would like to pass the txtcontractor to a form on load event. The form has txtcontractor on it and pulls the information correctly, however, I do not have the go to record command. The startup form is frmMenu and the field name is txt contractor
the form I am trying to open with the load event is frmContractor and the field on form is contractor.

frmMenu- field txtcontractor is a unbound field txt



frmContractor - field Contractor is a txt field

Thanks in advance for your assistance

[ItsMe]

If I recall correctly, this is the syntax for referring to a control's value when the control resides on another form.

Forms!frmFormName!txtControlName.Value

You will need to use a different syntax if the control resides within a subform of another form.

http://access.mvps.org/access/forms/frm0031.htm