How to disable form?

B

Brett

I have a form with a combo box on it. The user selects something in the
combo box and a VB.NET app is called. The VBA code looks like this:

stAppName = "C:\myFiles\ABC\Sync.exe"
Call Shell(stAppName, 1)

The above program does something while displaying a progress bar then closes
itself. While this is occuring, I'd like to disable in the Access form. I
could put

form.visible = false
-- do something --
form.visible = true

The above occurs immediately on the form. The VBA code starts the app and
immediately returns control back to Access, which turns the form.visible to
true. The user never notices the form was invisible because Access isn't
waiting for the Sync.exe program to finish executing.

How can I disable the form after the user makes a selection from the combo
box and wait for the application to finish before enabling the combo?

Thanks,
Brett.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top