Heenan, Lambert
Lambert.Heenan at chartisinsurance.com
Wed Jun 16 13:05:51 CDT 2010
Have you tried decompiling this MDB file? I just had an issue today getting spurious Error 49's (Bad DLL calling convention). In stepping thought the code I saw that the error was happening when a Sub call returned , but no error had happened in the sub, yet my code execution jumped directly into the error handler. I quick decompile and the problem went away. On another note, instead of using all those commas for the optional parameters to .OpenForm you can use this syntax (but it still will not solve your problem) docmd.OpenForm "frmRpoAddPart",OpenArgs:="2|966" Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee Sent: Wednesday, June 16, 2010 1:40 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] OpenArgs issue in A2207 This is nuts. It now shows up as null, no matter what I try, if I call it from the immediate window docmd.OpenForm "frmRpoAddPart",,,,,,"2|966" but if I call it from another form, it works as suggested. I usually do use a global function, but I wanted to open a quick form in one of three modes, so I thought a quick pass of a variable would work. I hate how something so stupid and simple can hold me up like this. :) -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com