Form property

[fabioltj]

Hello everyone...

I need to get a info. from the other FORM and insert in a loaded form. So, I wrote:

Private Sub Command2_Click()
Dim Variable As Integer

Variable = Forms!base!baseDetails.Form!Superior

also I tried: Variable = Forms![base].Form![superior]

where:
base is the other form.
Superior is a field that contain the value that I need.

Error
Run-time error '2450'
Access can't find the form 'base' referred to in a macro expression

What's wrong? Any directions???

 

[Mile-O]

Is the form called base opened?

 

[fabioltj]

No, it is not. The Form called "base" is not opened in the moment I want to take the information from it, but it is included in the same file.
I tested with the Form "base" opened and this code, mentioned above, works. I got the data that I need from that form.
However, Is it possible to do the same without open the form ?

 

[Rich]

No it isn't