Help with timing delay for command buttons

[Datament]

I have an Access form F_GetData with eleven controls which are used for filtering specific information to be appended to another form F_Receiver via a query q_AppendData.


There are two buttons on form f_GetData cmd1 and cmd2, but only cmd2 is visible (cmd1 sits under cmd2 not visible). On click of the visible cmd2, Cmd1 opens and runs q_AppendData and cmd2 opens another form F_Receiver with the data from q_AppendData.

I had to make cmd1 not visible because we don't want users to click on too many buttons. When cmd2 is clicked, it also clicks cmd1 without users knowing that. However, I need cmd1 to finish running q_AppendData before cmd2 open F_Receiver. If cmd1 does not find any data to retrieve, I need a message to show that, and the eleven controls to go blank.

I currently have both buttons visible and functioning properly. but would ask for some guidance if I can time delay cmd2 to let cmd1 complete its operation first.

I greatly would appreciate suggestions from you. Many thanks.

[CJ_London]

Have you tried using doevents after you call cmd1 and before you run the rest of the code in cmd2? Google to find out more

[Welshgasman]

Why not hav ejust the one button?

When are going to want to run the code in cmd2 and never the code in cmd1?