Passing variables between forms?

[Tails]

I'm new-ish to access and I am trying to take input on one form, and pass it
to another.

I tried to declare a Public variable in general declaractions but it doesn't
seem to be working - the variable is always empty when the second form
loads?

Is there another way please?

Thanks.

 

[Mike Painter]

I'm new-ish to access and I am trying to take input on one form, and
pass it to another.

I tried to declare a Public variable in general declaractions but it
doesn't seem to be working - the variable is always empty when the
second form loads?

Is there another way please?

If the input is into a bound form then there is no need for variables but
you might have to requery the recordsource.
If the information is unbound then you will have to use code to place the
information into the variable
MyVariable = Me!SomeField and more code to place it in the other unbound
field, probably the OnCurrent event.
You could also pass it to the form with the Args portion of OpenForm.

 

[Ken Snell]

see reply in other newsgroup where you also posted this same message

 

[Tails]

If the input is into a bound form then there is no need for variables but
you might have to requery the recordsource.
If the information is unbound then you will have to use code to place the
information into the variable
MyVariable = Me!SomeField and more code to place it in the other unbound
field, probably the OnCurrent event.
You could also pass it to the form with the Args portion of OpenForm.

Thank you to you, and also to Ken. It was an unbound control, so passing it
the way you described seemed like the best way.

It works now anyway, so thanks for taking the time to help a newbie!