how to pass parameters from one form to another?

[frag]

Hi there, this is frag! X-)

I want to pass an array from form 'a' to form 'b' (which is called by form 'a'). Do you have any ideas how to realize this? I tried it with:

'in form_a
DoCmd.OpenForm "form_b(myArray)"

'in form_b
Private Sub Form_Load(anotherArray as Variant)
End Sub

...but that didn't work!

This VBA-stuff is starting to tick me off! %-(

thanx!

cya

frag patrick.metz@epost.de

 

[frag]

Hello everybody!

I just figured out how to pass a value to one form to another.

'in form_a

Dim test As Interger

DoCmd.OpenForm "from_b", acNormal, , , , acWindowNormal, test

'in form_b

Dim test As Integer

test = me.OpenArgs


BUT I STILL HAVE A PROBLEM!! :-(

How to i pass SEVERAL values?

thanx!

frag patrick.metz@epost.de