Show/hide item per record

[dixxy12]

Hi everyone,

I am trying to have a command button visible or not visible on a continuous form base on the value of a text box.

So for instance,

if txtQTSBO.Value > 0 then
  cmdBO.visible = false
    else
  cmdBO.visible = true
end if

the problem i am having is is either shows for all records or does not show at all...i would like it to show for individuals recoreds based on that text box value.

How could i acheive this?

Thanks

Sylvain

 

[PHV]

This is standard behaviour for unbound controls in the detail section of a continuous form.
You may place the command button in the header or footer section of the form and put the following code in the Current event procedure of the form and the AfterUpdate event procedure of txtQTSBO.

Me!cmdBO.Visible = (Me!txtQTSBO.Value <= 0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya dixxy12 . . .

You can also [blue]simulate a command button[/blue] with an unbound textbox and [blue]use Conditional Formatting![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[dixxy12]

thanks guys...used a mixed of both to make it work...