My Code doesn't work properly

[cho]

Hi All,

I've made a code like this
But it seems there is something wrong.
The form " load " keep opening
although the form " Reject Rank " is opening.
Would somebody like to figure it out for me.
Thank's

Private Sub Command22_Click()
Me.Visible = False
DoCmd.Close acForm, " Menu DC "
DoCmd.OpenForm " load ", acNormal
DoCmd.SetWarnings False
DoCmd.OpenQuery " Reject Rank ", acViewNormal, acEdit
DoCmd.SetWarnings True
DoCmd.OpenForm " Reject Rank ", acNormal
DoCmd.Close acForm, " load "

 

[Stefan Hoffmann]

hi,

I've made a code like this
But it seems there is something wrong.
The form " load " keep opening
although the form " Reject Rank " is opening.
Would somebody like to figure it out for me.
Thank's

Private Sub Command22_Click()
Me.Visible = False
DoCmd.Close acForm, " Menu DC "
DoCmd.OpenForm " load ", acNormal
DoCmd.SetWarnings False
DoCmd.OpenQuery " Reject Rank ", acViewNormal, acEdit
DoCmd.SetWarnings True
DoCmd.OpenForm " Reject Rank ", acNormal
DoCmd.Close acForm, " load "

As you are not using the acDialog window mode, the complete code is
executed at once.


mfG
--> stefan <--

 

[Guest]

Hi

What are you trying to achieve here? You seem to be opening the 'load' form
then immediately closing it without it being used for anything?

Cheers.

BW