Calling a variable from another form

[rblivewire]

I have three forms that all have variables in the vb code. The form
takes these variables from the field on one form and does a
calculation. I need to know how to call this variable that is holding
the solution so that I can post it on my 3rd form.

 

[Guest]

If your variable is in a control--From the form that does not have the
variable you can use an event proceedure with VBA like this:

Me.myControlName = Forms!myFormName!myControlName

Hunter57
http://churchmanagementsoftware.googlepages.com/

 

[Guest]

It's me agian,

If your control's RecordSource is a Calculation, your VBA would be

Me.myControlName = Forms!myFormName!myControlName.Value

I forgot to add .value to the end of the VBA

Hunter57
Just huntin' for the right data.
http://churchmanagementsoftware.googlepages.com

 

[John W. Vinson]

I have three forms that all have variables in the vb code. The form
takes these variables from the field on one form and does a
calculation. I need to know how to call this variable that is holding
the solution so that I can post it on my 3rd form.

It's a lot simpler to use a reference to the form itself, rather than storing
the value in a variable: [Forms]![NameOfForm]![NameOfControl]

If you really want to use a variable, put a line

Public variablename As Integer

(or whatever datatype) at the very top of a Module in the modules tab. This
public variable will be available from any form in the database, to read or
write.

John W. Vinson [MVP]