can we make three forms, one is used to add, the other to edit the data and the third to just view the already entered data. i understand that you can set the lock property to yes to prevent changes in the view form. can we put a password or somthing on the edit form, and the add form should only display a new blank form for addition, but no previous records. thanks a lot

You don't need three separate forms. You can use the arguments for the OpenForm Method to control how a form is used. Also see help for:
Allow Edits
Allow Deletions
Allow Additions
Data Entry

[This message has been edited by Pat Hartman (edited 05-01-2001).]

thanx, but would you please tell me in detail. that how and when to allow additions only, allow edit only and allow view only.