Subform reference from Module

[mtompkins]

Ok gents - I've spent enough hours banging my head ...

I have a main form (frmMain) and a subform (frmReports) from which the user can select different reports to fire from a combo box (cboRptPicker) that sits on the subform.

When the button for generating the reports fires (also on the subform) it goes to a module that contains the following code:

rptNameStr = Forms!frmMain!frmReports!Forms.cboRptPicker.Value

The form(s) Main and Sub are open at the time this fires. The response is 'can't find the field frmReports refered to..'

I've also tried using this very helpful website for the different patterns (

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

however I'm at a loss.

Help is greatly appreciated.

 

[PHV]

rptNameStr = Forms!frmMain![frmReports control name].Form!cboRptPicker.Value

Have a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mtompkins]

Hi PHV - this is absolutely the issue at hand but I'm having difficulty navigating through it ..

Any chance I can have a helping hand?

The subreport is on a Tab control - which might be part of this math.

Thanks

 

[PHV]

Why not follow the expression builder (loaded forms ...)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mtompkins]

That did the trick - it was pulling the subreport control name.

Expression builder pulled it.