Toggle Command Button based upon field value..

E

Eric

In the detail section of a form, I have a command button
that I want to enable (or make invisible) if the current
recordset has a column value of -1...how can I do
this ... I've looked through all of the events for the
detail page and can't seem to make the correlation to
disabling JUST the current button for the particular
recordset entry...

Thanks!

Eric
 
J

Jim Allensworth

In the detail section of a form, I have a command button
that I want to enable (or make invisible) if the current
recordset has a column value of -1...how can I do
this ... I've looked through all of the events for the
detail page and can't seem to make the correlation to
disabling JUST the current button for the particular
recordset entry...

Thanks!

Eric
Click to expand...

I'm assuming a Yes/No (-1/0) type field.

Something like this would make the command button visible if the value
is -1 (true) ...

Me.cmdMyButton.Visible = Me.MyField

Not visible if it is 0 (False)


- Jim
 
Top