access: Command button property

[Sam]

Trying to change the visible property on a command button (access97) based
on a record felid on the form.

The felid is a check box felid and I am trying to make the button disappear
with the check box s checked.

The commend button name is command36 and the check bx feild is named [Multi
User].

I have written the following code:
IIf Me![Multi User] = True, Me!Command36.Vi sible = -1, Me!Command36.Vi sible
= 0

The visible functions are working if I put them in the "form load" area of
the vbcode, but the code will not look at the value of the check box.

Any ideas?

[Trevor Best]

On Fri, 05 Sep 2003 06:37:53 GMT in comp.databases. ms-access, "Sam"
<sa********@hot mail.com> wrote:

Trying to change the visible property on a command button (access97) based
on a record felid on the form.

The felid is a check box felid and I am trying to make the button disappear
with the check box s checked.

The commend button name is command36 and the check bx feild is named [Multi
User].

I have written the following code:
IIf Me![Multi User] = True, Me!Command36.Vi sible = -1, Me!Command36.Vi sible
= 0

The visible functions are working if I put them in the "form load" area of
the vbcode, but the code will not look at the value of the check box.

You want the code in the AfterUpdate event of the checkbox, if the
checkbox is bound then in Form_Current too.

BTW, your code is a bit long winded for what you want to do and the
syntax is not correct and it's logic conflicts with your explaination
in your second paragraph:

Command36.Visib le = Not [Multi User].Value

--
A)bort, R)etry, I)nfluence with large hammer.

(replace sithlord with trevor for email)

[Sam]

Thanks trevor, the code positions need to be refined but over the result I
was looking for was acheived.

Thanks again

Sam
"Trevor Best" <bouncer@localh ost> wrote in message
news:vg******** *************** *********@4ax.c om...

On Fri, 05 Sep 2003 06:37:53 GMT in comp.databases. ms-access, "Sam"
<sa********@hot mail.com> wrote:

Trying to change the visible property on a command button (access97) basedon a record felid on the form.

The felid is a check box felid and I am trying to make the button disappearwith the check box s checked.

The commend button name is command36 and the check bx feild is named [MultiUser].

I have written the following code:
IIf Me![Multi User] = True, Me!Command36.Vi sible = -1, Me!Command36.Vi sible= 0

The visible functions are working if I put them in the "form load" area ofthe vbcode, but the code will not look at the value of the check box.

You want the code in the AfterUpdate event of the checkbox, if the
checkbox is bound then in Form_Current too.

BTW, your code is a bit long winded for what you want to do and the
syntax is not correct and it's logic conflicts with your explaination
in your second paragraph:

Command36.Visib le = Not [Multi User].Value

--
A)bort, R)etry, I)nfluence with large hammer.

(replace sithlord with trevor for email)