Trouble w/ OpenArgs

[Pamela]

I have a command button on FormA to open FormB. The OpenArgs property for
this button on FormA is set to Me!AssignmentID. On the OnLoad event of
FormB, I have Me.AssignmentID = Me.OpenArgs. I am using this same procedure
in other places of my db and it works perfectly, but in this instance, it
doesn't carry the AssignmentID across...any ideas? Are there any other
underlying requirements to make this work? Thanks so much!

 

[Rick Brandt]

I have a command button on FormA to open FormB. The OpenArgs
property for this button on FormA is set to Me!AssignmentID. On the
OnLoad event of FormB, I have Me.AssignmentID = Me.OpenArgs. I am
using this same procedure in other places of my db and it works
perfectly, but in this instance, it doesn't carry the AssignmentID
across...any ideas? Are there any other underlying requirements to
make this work? Thanks so much!

Is the record on formA a new record? If it is then you likely need to save
that record before opening FormB.

 

[Pamela]

Thanks for your reply. It is a new record, but I have code in a previous
field to save. The error I'm getting is: The expression in argument 6 has
an invalid value. I've reviewed all the data entry and it is correct -- any
ideas how I can track down this "argument 6?" I've never run into anything
like that before. Thanks!!

 

[boblarson]

How about putting your code for opening the form here?
--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[Rick Brandt]

Thanks for your reply. It is a new record, but I have code in a
previous field to save. The error I'm getting is: The expression in
argument 6 has an invalid value. I've reviewed all the data entry
and it is correct -- any ideas how I can track down this "argument
6?" I've never run into anything like that before. Thanks!!

Okay, your original post said nothing about getting an error. What code is
producing the error? Code in FormA or code in FormB? What event and what
is the line of code?