Field Visible on a form depending on a table repsonse

[GraemeG]

Hello.

Is there a way to make a field on a form visible or not visible dependant on repsonses made in a table.



I.e
I want a button for admin tools to appear when the admin user is logged in.

Private Sub Form_Load()
If Tbl_Users_EngineerID = "Administrator" And Tbl_Users_fldLoggedIn = True Then
Me.cmdAdminTools.Visible = True
Else
Me.cmdAdminTools.Visible = False
End If
End Sub

I have the above code but it does not work.
Any help appreciated.

[pbaldy]

You can't get the table value that way. You'll need to open a recordset or use DLookup() to get them.

[kennejd]

Your example might work if the form is bound to a table or query that contains those fields. However, the syntax will probably need to be changed.