>>I have a command button where I want to leave the OnClick Event Blank.
>>I want to set it from the previous form. If I open it from form1 the
[quoted text clipped - 14 lines]
> Call SomeOtherSub
> End Select
>> No need to leave the OnClick blank. Just put your various code
>> routines in their own functions or sub-routines and then have your
[quoted text clipped - 9 lines]
>>
> Looks good Rick, but how do you use the OpenArgs tocall the form?
OpenArgs has a dual personality. It is an optional argument that can be
used in the OpenForm method.
DoCmd.OpenForm "FormName",,,,,,"Some String Value"
It is also a property of a form that can be referenced by any code in that
form. It's just that the OpenArgs property will be Null (or a zero length
string perhaps) if the form is not opened with OpenForm having the OpenArgs
argument supplied.

Signature
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
DS - 15 Nov 2005 21:38 GMT
>>>No need to leave the OnClick blank. Just put your various code
>>>routines in their own functions or sub-routines and then have your
[quoted text clipped - 19 lines]
> string perhaps) if the form is not opened with OpenForm having the OpenArgs
> argument supplied.
Thanks Rick, On target as always!!
DS