Form in Add Mode

[Phil2951]

I'm new to Access 2010 and have some knowledge of Access 2007. I'm using Access and a front end to a SQL database. I have created a form and try to open it in Add mode. Every time I open the from and populate a operator name, data in the table populates the form. I can still enter new data, but I should open in Add mode with out any data. Any help is greatly appreciated.
Thanks............Phil2951

[John_G]

Hi -

Set the Data Entry property of the form to Yes. By doing that the form will always open to a new record.

John

[Missinglinq]

...Every time I open the from and populate a operator name, data in the table populates the form...

This behavior has to be something that you or someone else (if you didn't originally design the app) has added to the Form; this is not a default behavior, it sounds like it's a 'search' Form. Does it open with all Controls empty prior to entering the operator name?

...should open in Add mode with out any data

John's suggestion will open on a New Record, but you will not be able to view or edit existing Records. Is this acceptable for your purpose? If you need to be able to handle existing Records, as well as New Records, leave the Data Entry Property to No and use code like this:

Private Sub Form_Load()
  DoCmd.GoToRecord , , acNewRec
End Sub

Are you, per chance, opening this Form from another Form?

A little more information on your actual scenario would probably help us help you with this thing!

Linq ;0)>