Passing Field Values between Forms

[Guest]

I would like to know how to make FieldA on FormB have the same text upon
opening the form as FieldA FormA has. How do I pass Text values for fields
between forms like that? I thank everyone in advance for your help.

Kalor

 

[Ron2005]

On FormB as the record source for FieldA put

=Forms![FormA]![FieldA]

If you use the wizard got to forms then formA and then find FieldA.
When you leave the wizard the above code is what you will see.

 

[RobFMS]

The DoCmd.OpenForm has a parameter called "OpenArgs". This is another method
to pass data to a form. Review the help file for more details.

Additionally, here is a tip that might be of interest:

Tip #13: Passing Parameter to Access Form OpenArgs
http://www.fmsinc.com/free/tips.html#TipAccess13

HTH
--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

 

[Guest]

For greater flexibility in passing values between forms via the OpenArgs
mechansism you'll find a demo at the link below of a method developed by
Stuart McCall and myself which enables not only single values to be passed
but also multiple values as named arguments or as a tokenised value list:


http://community.netscape.com/n/pfx...yMessages&tsn=1&tid=24091&webtag=ws-msdevapps

Ken Sheridan
Stafford, England