View all records after opening in "add new record" format

[sdavid74]

I have a form set to open up to a blank record by inserting this script, (from this forum),

DoCmd.OpenForm "OrientationMain", , , , acFormAdd

and from this page I can't see any of the old records, which I'm OK with, but when I try to insert a command button that will open up the form in regular mode, it doesn't do anything. Any ideas as to how I can see the rest of the records?

 

[thornmastr]

In the onclick event of your button include the following

Me.dataentry = false
Me.requery

Robert Berman

 

[sdavid74]

Robert, thanks for the tip. That's exactly what I needed.