How to disable form?

[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.

 

[Larry Daugherty]

This

http://www.mvps.org/access/api/api0004.htm

will take you to an API solution that you can copy and modify.

HTH