Forms question

[TheWennerWoman]

Hello, I have frm_Main_Menu containing several buttons. If one of them is pressed, a second form pops up asking for the user to enter a company code. When they click OK on that, the second form unloads and some code goes away to get data from a database. While this is happening, I'd like a form to pop up saying "data being retrieved, please wait" (ideally right after they clicked OK). When the data is returned I want the "data being retrieved" form to go away.

How can I achieve this?

I keep running into "error 402 - must close or hide topmost modal form first"?

 

[Micron]

This is Access or no? Reads like it is, but you posted in Excel forum. Post your code so someone has something to work with? Or in the event that closes said form add code to open the message form first, then do whatever to get the data. When that is done, control will pass back to this procedure whereupon you can close the message form.

 

[TheWennerWoman]

This is Access or no? Reads like it is, but you posted in Excel forum. Post your code so someone has something to work with? Or in the event that closes said form add code to open the message form first, then do whatever to get the data. When that is done, control will pass back to this procedure whereupon you can close the message form.

It's Excel.

Private Sub CommandButton1_Click()
Range("co_chosen").Value = Me.cmb_Company_Code.Value
frm_wait.Show
Call getrecords
frm_wait.Hide
Unload Me
frm_Tabbed.Show
End Sub

frm_wait.Show appears fine ("please wait, data is being retrieved") but it doesn't get beyond frm_wait.hide....the forms just sits there and if I red x it to close that's when I get the "error 402 - must close or hide topmost modal form first"

 

[RoryA]

You could use a multipage on your second form (you can hide the tabs) and on the second page just have a label with the "please wait..." text on it. When you click the button, switch to the second page, then hide the form when the retrieval is over (a form shouldn't really unload itself - whatever called it should take care of that).

 

[Micron]

but it doesn't get beyond frm_wait.hide

If Excel is a single thread process like Access then it's because control passes to the process that gets the data. In the meantime you can't do much in the code, if anything, until control passes back to your code. If you just wait for the data retrieval process to complete, your next line of code should execute. Does that not happen?