I want to open my form as a blank?

  • Thread starter Thread starter jo
  • Start date Start date
J

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
 
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.
 
Hi Douglas thanks for your reply but when set Edits to false I can not edit
anything so this would be no good??
 
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
 
Hi Allen that works a treat!! Briliant exactly what I wanted thank you!!
Jo

Allen Browne said:
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.

jo said:
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
Click to expand...
Click to expand...
 
Back
Top