what property looks to see if some other form is o (97)

Topic

New Reply

I want to code so that the click of a button won

Reply | Quote

Replies

What application are you working in? Which button are you trying to disable or alter? The simplest way is to make the form modal so that the user can’t click a button or menu item outside the form until they close the form.

Reply | Quote

using access97 & it’s basically a switchboard w/buttons on it. the swtichboard opens 2 forms & only 1 of these forms can be open at one time, not both. that’s what i’m trying to achieve in vba unless there’s some better solution, i don’t think modal applies does it?

Reply | Quote

Sure modal applies. If you open the form modal and popup, that is, open it as a dialog, then the user can’t click anything else until he closes that form.

If you’re using a switchboard created using the Switchboard Manager add-in, then you can create a macro that opens that particular form using a WindowMode argument of Dialog and use the Run Macro action in the Switchboard to launch that form as a popup modal form. That means it remains on top and keeps the focus until it is closed, so make sure you give the user a method for closing the form.

Reply | Quote