Blank Forms

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

How do you get a form to open to the user blank? When
mine opens the first entry is always the default. I just
want all lines blank-so the user can start their new entry.
 
Hi Nikki

one way, set the Data Entry property of the form to Yes
(design view, form properties, Data tab - Data Entry = Yes)

however, then they can't see the other records at all.

OR
in the OnOpen event of the form enter the following

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec

End Sub

(design view, form properties, event tab, click in OnOpen line, click on
...., choose Code Builder - type Docmd line between sub & end sub)

this will open to a blank record but they can still get to the other
records.

Hope this helps
Cheers
JulieD
 
Nikki
For the form create an event procedure for "On Open" like below

Private Sub Form_Open(Cancel As Integer
DoCmd.GoToRecord , , acNewRe
End Su

Hope this helps
amcgaffi

----- Nikki wrote: ----

How do you get a form to open to the user blank? When
mine opens the first entry is always the default. I just
want all lines blank-so the user can start their new entry
 
Back
Top