OpenArgs is null?

[Maury Markowitz]

Is there something obviously wrong here? Here's the code in one form...

Private Sub Form_DblClick(Cancel As Integer)
descr = CStr(Me!cusip) & ";" & CStr(Me!TICKER) & ";" &
CStr(Me!description)
DoCmd.OpenForm "Map Security", acNormal, , , , , descr
End Sub

here's the code in "Map Security":

Private Sub Form_Open(Cancel As Integer)
MsgBox Me.OpenArgs
End Sub

OpenArgs is always null, even though "descr" is not null. ???

Maury

 

[Ken Snell \(MVP\)]

Try using the second form's Load event instead of the Open event.

 

[Dirk Goldgar]

Is there something obviously wrong here? Here's the code in one form...

Private Sub Form_DblClick(Cancel As Integer)
descr = CStr(Me!cusip) & ";" & CStr(Me!TICKER) & ";" &
CStr(Me!description)
DoCmd.OpenForm "Map Security", acNormal, , , , , descr
End Sub

here's the code in "Map Security":

Private Sub Form_Open(Cancel As Integer)
MsgBox Me.OpenArgs
End Sub

OpenArgs is always null, even though "descr" is not null. ???

That seems odd, and I can't reproduce it. I expect the OpenArgs property to
work in the form's Open event, and it did in the form I tested. I was using
A2003 with an MDB file. What Access version are you using? As I recall,
you work with ADPs, and I suppose it could be different in an ADP, though
that would surprise me.

Set up a simple pair of test forms, and see what results you get.