Continuous Form and Button Issue

[chloe67]

I have an Equipment Entry continuous subform. The Equipment Entry subform lists all the equipment in a particular room. Within the Equipment Entry subform there is a field called EquipmentType and a button called Maintenance.

If "projector" is entered into the EquipmentType field, I would like the Maintenance button to appear beside that record, but not beside any of the other records.

I have tried using the Visible property for the button and the OnCurrent event for the form, but this shows the button on all the records if the record containing "projector" is selected.

Is there a way for the button to only be visible on the record containing "projector" and none of the others?

Help!!

 

[TheAceMan1]

How are ya chloe67 . . . . .

This is [blue]typical behavior[/blue] of a button in the [blue]detail[/blue] area.

If you have Access 2K or higher you can try this:
[ol][li]Remove/delete the command button.[/li]
[li]Add a textbox to the detail area and set the following properties ([blue]simulates the look of a command button[/blue]):
[ol a][li]Special Effect [purple]Raised[/purple][/li]
[li]Back Color ([purple]select light gray)[/purple][/li]
[li]Text Align [purple]Center[/purple][/li]
[li]Control Source [purple]="Maintenance"[/purple][/li][/ol][/li]
[li] Have a look at [blue]Conditional Formatting[/blue][/li][/ol]

See Ya! . . . . . .