Hide Records In Forms

[data808]

Ideally, I would like to create a password just to open the database and also prevent access to records in the form itself. Every time I open the form to enter data, it opens up to the last entry that was entered. Not to mention the fact that you can scroll through all the records with the back arrow button. This is what I want to prevent. I just want it so when you open the form, it opens up to a blank form ready to take in a new record. Then only giving the person with the password to the database to make changes to the records. Is this possible? Thanks in advance.

[Missinglinq]

In Form Design View, go to Properties - Data and set the Form's Data Entry Property to Yes. This will only allow the entering of New Records; Records from previous sessions will not be available.

As for the password to view/edit all Records (that is what you're asking, isn't it?) If the password is correct simply use this line of code:

Me.DataEntry = False

Linq ;0)>

[data808]

Ok thanks i will try that for the form to add new records. As for the password thing, i wanted it for the database table that the records are saved to. Would the code you provided go into visual basic? Also is there a way that many people can be adding in records at the sametime from different computers? Sorry i havent tested this yet so it might already work but it just got me confused as to how the record would be added to the database with many people entering all at once.

[data808]

i need more steps on how to create a password please. a tutorial if possible? thanks

[orange]

Read this dialog and see if you get some ideas
http://www.mrexcel.com/forum/microso...ns-system.html