[AccessD] OpenArgs issue in A2207

:)


OK, I thought I was brain farting yesterday, but I know this has
something to do with A2007.

I've used this code many times:

Private Sub Form_Open(Cancel As Integer)
'Opening Args = Mode | RPOID
Dim arrX As Variant
    '****Mode*******
    arrX = Split(Me.OpenArgs, "|") 'Gives error
    'arrX = Split(Nz(Me.OpenArgs, "1|0"), "|") This doesn't give the error
    Me.txtMode = Nz(arrX(0), 1)
    '**** RPOID ******
    If trim(Nz(arrX(1), "")) <> "" Then Me.txtRPOID = arrX(1)

I am now getting an error on Me.Openargs if it is not wrapped in an
NZ() function, even though I am passing it a text string.

I get a Run-time error 94, Invalid use of Null.

Has anybody else seen this (using my example from yesterday) using
A2007 or am I just getting goofy in my old age?

D



On Tue, Jun 15, 2010 at 10:09 AM, Kenneth Ismert <kismert at gmail.com> wrote:
>> From: David McAfee <davidmcafee at gmail.com>
>> Subject: [AccessD] OpenArgs issue in A2207
>>
>
> Is this the great-great-great grandson of the current David McAfee,
> communicating to us from 200 years in the future via a wormhole?
>
> What's life like with flying cars and automatic dog walks? Are your cyborg
> masters pleasant? Have the Cubs won a World Series yet?
>
> ;)
>
> Ken
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>