I have an update form which retrieve data from an Access DB. Everything works great. My question is that I want to use this same update form for both Access level (Admin, User) but, if "Admin" login in, he will have access to update everything. If a "User" logged in, he will have limited access to update to certain field. Basically, can you hide some of the fields in the form depending on your access level?
Thanks
-Dave

You can hide anything you like based on the value held in a variable. If you are using the standard UD log in server behaviour the session variable created for user acces level is MM_UserAuthorization, so you can hide a textfield like this:

<% If Session("MM_UserAuthorization" <> 1 Then %>
<input type="text" name="WhatEver" value="<%= RecordsetName.Fields.Item("YourFieldName".Value %>">
<% End If %>

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo