Setting variables in a form from a subordinate form (NOT a subform)

[GraeagleBill]

I can't seem to find the correct syntax where I have a subordinate form wanting to set a variable Dim'd in the form that opened it, i.e., DoCmd.Openform MyForm.

Forms!frmRecipesMain!Form.strRecipientName = Me.ContributorName

strRecipientName is the variable Dim'd in the form frmRecipesMain and it is from that form that the subordinate form is opened. A2003 reports that it can't find the form frmRecipesMain.

What have I missed here?

Thanks,


Bill

[ssanfu]

strRecipientName is the variable Dim'd in the

This tells me the variable is in VBA code. It is not a control on a form so you cannot reference it using "Forms!frmRecipesMain!Form.strRecipientName".
Is the variable declared in a procedure that is declared PRIVATE?

You could use the "open arguments" argument to pass the data to the subordinate form.



DoCmd.OpenForm "MyForm",,,,,,Me.ContributorName (see help)

Syntax:
DoCmd.OpenForm formname[, view][, filtername][, wherecondition][, datamode][, windowmode][, openargs]



Then run code in the subordinate form to do what you want with the data in the openargs argument.

[ketbdnetbp]

Bill - A few questions...

Form1 = frmRecipesMain
Form2 = What is it's name?

Is Me.ContributorName on form1 or form2?

When you say strRecipientName was dimmed on form1, was it something like...

dim strRecipientName as string
strRecipientName = ???What???? Is the value in a control? If so, what is the name of that control?

Also, are both forms open when you get the error?

Lastly, which form is the destination, i.e. where you want to set the value?

Jim

[ketbdnetbp]

Sorry Steve, didn't see your post before replying. Jim

[June7]

One form cannot set a variable declared in another form. Only the procedure that declares the variable can set the variable, unless variable has been globally declared in a general module.

A form can set value in a control on another form.

[stmoong]

If you need to set the variable "strRecipientName" before the "frmRecipesMain" is loaded, then you have the following options:
1) Use DoCmd.OpenForm as stated by Steve (IMHO, this approach is the cleanest)
2) Use a module to store as global variable as stated by June7
3) Use a hidden form to store the name in a text box (ugly approach)

For the purpose of form A setting a variable in form B ("frmRecipesMain") after form B is loaded, you can either use a module and store as global variable Or using the OO-approach and extend the form. Not exactly better, because you can still set it through the DoCmd.OpenForm approach, but for the purpose of exploring, here it is

In the code behind for form B:

Dim mStrRecipientName as String
.....
(some additional code)
.....

Public Sub SetRecipientName(ByVal pVal as String)
    'Here you can even do some validation prior to setting the value
    mStrRecipientName = pVal
End Sub

Then, in your code behind for the other form, you can do this. Just ensure that the frmRecipesMain is loaded before you call the subroutine.

.....
Forms!frmRecipesMain.SetRecipientName "some names"
.....