Nigel,

Can you post the following code:

1) The routine in formA that calls the function in the code module
2) The routine in the code module that loads and shows FormB
3) Any unload code in FormB

Thanks.

Cardyin

--------------------------------------
Cardyin Kim
C/S & Web Development Analyst
Information Services
San Antonio Community Hospital
ckim@s...     (xxx)xxx-xxxx     
--------------------------------------


-----Original Message-----
From: Nigel Parker [mailto:Nigel.Parker@c...]
Sent: Thursday, July 26, 2001 12:38 AM
To: professional vb
Subject: [pro_vb] RE: Runtime Error 5


Hi Cardyin

When the form unloads, it just clears a few variables and then enters the
Form_Unload event.

Before I post the code, I forgot to mention that.................

The parent form (FormA) calls a routine within a code module (.bas) and
passes a few parameters.

The code in the .bas module function uses the parameters and then actually
loads (shows) the form (FormB)

Upon unloading FormB sets a value in the .bas code module to indicate
success / fail of its actions.

This value is then read by the parent form (FormA) upon return. (If runtime
error 5 doesn't appear!!)

Both the parent and child forms have code in the form activate event but I
have not used the
AppActivate statement anywhere.

Sorry that I forgot to mention this before!!

Regards

Nigel


> -----Original Message-----
> From:	Kim, Cardyin [SMTP:CKim@s...]
> Sent:	Wednesday, July 25, 2001 5:37 PM
> To:	professional vb
> Subject:	[pro_vb] RE: Runtime Error 5
> 
> Nigel,
> 
> Two things:
> 
> 1)  Can we have a clip of your unload code?
> 
> 2)  Would you happen to use the AppActivate statement in your code
> anywhere?
> 
> Cardyin
> 
> --------------------------------------
> Cardyin Kim
> C/S & Web Development Analyst
> Information Services
> San Antonio Community Hospital
> ckim@s...     (xxx)xxx-xxxx     
> --------------------------------------
>