Passing data problem

[gguy]

In the on current event of a form (Form_B) I am pulling data from another form (Form_A).

The problem is that sometimes I will need to go to form_B when form_A is not open. When that happens form_B will error out.

I need to figure out some form of an if statement to bypass the code that pulls the data from form_A if the form is not open. I tried the isnull with out success. Please help. GGuy

 

[jdwhytie]

can you trap the error with On Error? This way when the error comes in you can check to see if it is the error you want, and if it is then deal with it how you need and return it back to where you want.

 

[Rich]

If IsLoaded("FrmA") Then

 

[pbaldy]

Another way would be to check if form A is open using its IsLoaded property (or create a function).

 

[gguy]

Rich and Pbaldy. Thanks, I think that is what I am looking for. Unfortunatley, when I insert the code I get a compile error on the isloaded().

The error states "Sub or Function not defined". Could it be that I need to load an additional reference.

GGuy

 

[gguy]

Okay,

I followed the other threads on IsLoaded and solved my problem. Much thanks guys.

GGuy