Default open form to 'new record'?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When a form opens, it's to record #1. I'm entering fresh data regularly, and want the 'new rocord' to open by default, and perhaps have the option of going back to view the past records.
 
Hi Dean

here's an answer i gave another poster earlier this evening ...
***
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


Dean said:
When a form opens, it's to record #1. I'm entering fresh data regularly,
Click to expand...
and want the 'new rocord' to open by default, and perhaps have the option of
going back to view the past records.
 
Back
Top