Help Please (Buttons)

[rmartinez]

Hi everyone,

This question is probably going to sound stupid, but I don't know any VBA and need to get this done.

I want to be able to open a table using a button within a form, this forms has about 3 buttons within it. I want all the other buttons to be disabled once a table has been opened.

The following are the examples of the names of the tables and buttons:

Table: WUS
Buttons:
cmdWUS1
cmdWUS2
cmdWUS3

(These names are examples, not the actual name)

I want cmdWUS1 to open up WUS table, once this happens, I want all the buttons disabled. Once the table has been closed, I want the buttons to be enabled again. Can someone please help me. I have no idea what or how to start the code for this.

I asked a similar question earlier on and got an answer, but I'm still kind of lost.

 

[pbaldy]

First of all, you'll find most developers never expose the tables directly to the user. Users interact with forms and reports. What makes that particularly relevant for you here is that there is no event associated with closing an open table, so it would be tricky to know when it was closed. There are events associated with closing forms, that would let you do what you're asking.

In fact what I would do is not worry about disabling the buttons. I'd open a form based on your table using acDialog. That way the user can't work with anything but that form until they close it.