I have two queries, the first problem is creating user level security. I have tried to
use the wizard and protect all the objects in the database. I need to be the sole user of the admins group. Other users should only be able to read the data. I dont seem to have a problem adding the users in the wizard and adding to groups but once I re open the database there is no prompt for a
log in and in the security menu the users are not being displayed only myself.

The second problem is based on a form. I have a one to many relationship and I have input error messages to prevent duplicate entries. However when an existing id is entered by mistake and the error msg displayed I want to give the user a chance to re enter (which happens) but I dont want the last entry still to be seen. I want to clear the text box for the new input.

Can you give me any advice?

Regards
Hayley

I think this article will be of interest to you:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q165009

For you second question you can use code similar to this in the Before Update of your event:

If Not IsNull("[ID]","YourTable","[ID] = " & Me![ThisFieldsName]) Then
Msgbox "Duplicate ID"
Me.FieldName.Undo
Cancel = True
End if

I have the form set up to display the error message when the add record button is clicked. When I click ok to remove the error msgbox prompt the wrong no I have just entered is still there

Cant I use the requery function behind my text box to clear the last no so there is no text displayed in the box when i try to retype or does it have to be code?

Does anyone know?
Thanks
Hayley