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