how do i get forms to open up to a blank record

[Guest]

Some of my forms are related to only one table, some are related to 2 or more
tables. The problem i am having is my employees are over writing dadabase
information, because they don't reliaze the are typing into a particaly fill
out form. I need these forms to open to a new or blank record each time they
are opened. How do i do this. currently I am using access 2003, this database
was started out in 97 upgraded to 2000

 

[Paul Doree]

Clinton,

In the forms' on open event put (A2000 but I think it's the same in 2003):

DoCmd.GoToRecord , , acNewRec


This will ensure that when the form is opened it always opens to a new
record, not an existing one.

Paul

 

[Guest]

Clinton,

Paul's suggestion is exactly right, and will give your users the ability to
edit existing records, if that's what you intend.

If you don't want to allow access to any existing records, either set the
form's DataEntry property to Yes, or use the acFormAdd parameter to the
OpenForm method:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "YourForm"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd