Userform not activating

[Shodi]

Hi everyone..

I have two Userforms named frmSelectItems and frmUpdatePrices

frmUpdatePrices is called by clicking command button in frmSelectItems

My issue is that frmUpdatePrices initializes when the cmd button is clicked but after it shows, the code then goes back to the cmd button sub (in the frmSelectItem module) to end the routine before frmUpdatePrices activates.

As per my understanding, and please correct me if I'm wrong, this should not happen as when the "frmUpdatePrices.Show" code is executed, the code should then complete running through the subroutines for frmUpdatePrices and then come back the frmSelectItems subroutine to continue with the code that comes after "frmUpdatePrices.Show".

Can anyone tell me why this is happening and how I can get around this.. the problem is that if a condition is met I want to add a few codes (to frmSelectItems after "frmUpdatePrices.Show") that will pull up other userforms after the frmUpdatePrices.Show code in succession (they too will need to be active as they come one after the other - once one form is updated and unloaded the next will be called.)

Hope I have not confused the issue.

Please let me know if I have... and which part I need to clarify.

Thanks everyone.

 

[Legacy 456155]

Are you showing frmUpdatePrices modally? It should take the focus if shown modally.

 

[Shodi]

Are you showing frmUpdatePrices modally? It should take the focus if shown modally.

No I had to set modal to False as the frmUpdatePrices has a reference form "frmShowSizes" that can be called and may need to be kept in view while "frmUpdatePrices" is updated. I can set modal to true but that would require the user to pull up the "frmShowSizes" for reference, then close it and again pull it up if in doubt. Is there a way around this?

 

[Jaafar Tribak]

Have you tried Hiding the calling form before showing the callee.. something along these lines:

frmSelectItems.Hide
frmUpdatePrices.Show vbModeless

' rest of your code goes here ..

frmSelectItems.Show

 

[Legacy 456155]

frmUpdatePrices is called by clicking command button in frmSelectItems

Set the "TakeFocusOnClick" property of this commandbutton to false.

 

[Shodi]

T

Set the "TakeFocusOnClick" property of this commandbutton to false.

Thanks........

 

[Shodi]

Have you tried Hiding the calling form before showing the callee.. something along these lines:

frmSelectItems.Hide
frmUpdatePrices.Show vbModeless

' rest of your code goes here ..

frmSelectItems.Show

Thanks...