hiding buttons

[scimatic]

I have a form based on an inventory table, some but not all the equipment in the inventory table is linked to a maintenance log tabe. I'm wondering if it is possible to put a button on my form that will only be visible when you're currently viewing equipment that has a maintenance log associated with it in another table. And when the equipment you're currently viewing has no maintenance logs (or when the Equipment id is not found in the maintenance table) the button is not visible.

 

[AccessGuruCarl]

try this on the form's current event

if me.maintenance.id.value <> 0 then
me.YourButton.visible = True
else
me.YourButton.visible = False
end if

AccessGuruCarl
Programmers helping programmers
you can't find a better site.

 

[mph1]

You could try the following concept. The code would go in the OnLoad of the form.

If IsNul[EmployeeID] Then
buttonname.visible =false
Else buttonname.visible=true
End If

HTH

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106

 

[scimatic]

works great, thanks