Show/hide button depending on table data

[TUSSFC]

I'm looking for some code which will show a certain form button IF SQL criteria is met.

Basically, I have user data in a table with one field being 'Admin'. If the user which has logged in to the database has a 'Yes' value in the Admin field then I want the button to show. Otherwise it should be hidden.

I've got the SQl statement ready to go - can anyone suggest code?

Thanks.

 

[rainman89]

use a dlookup for your feild and if that is equal to admin then

buttonname.visible=true
else
buttonname.visible=false
end if

 

[TUSSFC]

Cheers bud - that was nice n easy!

 

[rainman89]

glad to help