Pass number from main form to third form

[mnsebastian]

Hello,

I have three forms:

1) frmMain - cboAssetNum
2) fsubproperties - Skip Command Button
3) fskip - Skip option group

I want to pass the cboAssetNum to the fskip form and update a table.
Below is the code I have:

DoCmd.RunSQL "INSERT INTO tblVendorAssignment (SkipDate, VendorID,
AssetNumber, SkipReason) VALUES (#" & Format(Me.txtcurrdate,
"mm/dd/yyyy") & "#, '" & Me.txtVendorID & "', '" & Me.cboAssetNum &
"','Slow Response')"

I keep getting the error can't reference parent property.

Can someone please help. Thank you!

 

[Guest]

You need to name the form / subform, me. only refers to the active form

TonyT

 

[mnsebastian]

This is what the code was:

DoCmd.RunSQL "INSERT INTO tblVendorAssignment (SkipDate, VendorID,
AssetNumber, SkipReason) VALUES (#" & Format(Me.txtcurrdate,
"mm/dd/yyyy") & "#, '" & Me.parent.txtVendorID & "', '" &
Me.cboAssetNum &
"','Slow Response')"

and I am getting that error. . .

 

[Guest]

try forms.MainFormName.SubFormName.form.ControlName

obviously the subformmname is only needed to reference a control on the
subform

look under help in sub forms for various syntax examples

hope this helps further.

TonyT

 

[mnsebastian]

Thank you I figured it out!

try forms.MainFormName.SubFormName.form.ControlName

obviously the subformmname is only needed to reference a control on the
subform

look under help in sub forms for various syntax examples

hope this helps further.

TonyT