I want to open my form as a blank?

[jo]

Hi I would like to open my form as a blank so that the info there now can not
be altered mistakenly by the user. But if i have the form as a Data Entry i
then cannot Find other records (Systems Find & Replace). Would you know how I
can do this if it can be done?? Thanks Jo

 

[Douglas J. Steele]

As you've discovered, setting the Data Entry property means that existing
data doesn't appear on the form.

See whether setting the form's Allow Edits property to False is what you
need.

 

[jo]

Hi Douglas thanks for your reply but when set Edits to false I can not edit
anything so this would be no good??

 

[Allen Browne]

Set the form's On Load property to:
[Event Procedure]

Then click the Build button (...) beside this.
Access opens the code window.

Insert this line between the other two:

Private Sub Form_Load()
If Not Me.NewRecord Then RunCommand acCmdRecordsGotoNew
End Sub

 

[Keith Wilby]

Hi Douglas thanks for your reply but when set Edits to false I can not
edit
anything so this would be no good??

Under what set of circumstances would you want the data to be read only?

Keith.
www.keithwilby.co.uk

 

[jo]

Hi Allen that works a treat!! Briliant exactly what I wanted thank you!!
Jo

Set the form's On Load property to:
[Event Procedure]

Then click the Build button (...) beside this.
Access opens the code window.

Insert this line between the other two:

Private Sub Form_Load()
If Not Me.NewRecord Then RunCommand acCmdRecordsGotoNew
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi I would like to open my form as a blank so that the info there now can
not
be altered mistakenly by the user. But if i have the form as a Data Entry
i
then cannot Find other records (Systems Find & Replace). Would you know
how I
can do this if it can be done?? Thanks Jo