I want my form to open blank

[uneek78]

I am using Access 2000. I am trying to get my form to open up blank. So that when a user prepares to enter information in the blanks there is no data already in the fields. I am familar with access, but have no idea about this VB coding stuff. So if you have the time and decide to answer my question I would need to know step-by-step how to incorporate anything that requires code to make this work. I don't understand ANY VB AT ALL!!!! Yeah, I'm pitiful. The 1st step is admittance. The 2nd step is YOU helping me. I'm about to lose my mind..........

 

[JANR]

In the properties for your form set DataEntry to YES.

JR

 

[uneek78]

I right-click and click properties and look through all the tabs. I don't have an option for Data Entry. Any idea where it might be?

 

[CEH]

First, how are you opening the form? If from a button.... Then the wizard will walk you thru the steps... But if it is not doing what you want look at the code... Put the form with the command button in design view, click the button, than right click it and pick "properties" You should see something in the "OnClick" event. (on the "Event" tab) it will say [Event Procedure].. Click on the 3 dots "..." this will open to your code. Should look something like this.......
Private Sub cmdAddtoForm_Click()
On Error GoTo Err_cmdAddtoForm_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "FormName"
DoCmd.OpenForm stDocName, , , , acFormAdd, acWindowNormal

Exit_cmdAddtoForm_Click:
Exit Sub

Err_cmdAddtoForm_Click:
MsgBox Err.Description
Resume Exit_cmdAddtoForm_Click

End Sub

In the above code the "acFormAdd" is what is going to set it to open in an Add mode.
Hope that gets you going in the right direction......

 

[JANR]

Under the DATA tab it shuld be the 8. choise. Just be sure the you have the properties of the FORM. MY access is in Norwegian and it reads Dataregistrering which translates to Dataentry or something to that effect

JR

 

[uneek78]

My 8th option is field look-up. I attached a picture of what I have.

 

[uneek78]

Found it!!!!! Thanks!!!!!!!!!!

 

[uneek78]

Thanks janr!!!!!