[AccessD] OpenArggggggghhhhhhsssss

Rocky Smolin rockysmolin at bchacc.com
Thu Aug 11 11:47:14 CDT 2011


If you put MsgBox "*" & Nz(Me.Openargs) & "*"  as the first line in the Open
event, what does it print?

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
(VBACreations.Com)
Sent: August 11, 2011 9:32 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] OpenArggggggghhhhhhsssss


I am sending a nonempty string to openargs but when the form is closing I
call a subprocedure on the form which is closing -- and when that procedure
refers to OpenArgs, it is frequently null for reasons which I cannot
understand....? So I tried assigning the openargs to a module level string
variable instead, on _Load. I saw that the OpenArgs was null in that
assignment statement, throwing an error. So I checked the call stack, went
to the line of code which was opening the form, and saw that it was fine -
the strOpenArgs variable I was passing as the value for the OpenArgs
argument was a populated string. Anyone seen this?

My workaround is to give up on OpenArgs and resort to a global string
variable.

Thanks

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list