Need to hide previous Form entries

[SeanH77]

Once the form is completed and they click or move to a new entry, I need to
hide the previous entry. The form is set to Data Entry: Yes, but that only
hides records from a previous session, we don't want to have to close the
Form and re-open it after each record entry. Any/all help is appreciated!
Sean

 

[Allen Browne]

What happens if you requery the form in its AfterInsert event?

1. Set the form's AfterInsert property to:
[Event Procedure]

2. Click the Build button (...) beside this.
Access opens the code window.

3. Between the "Private Sub..." and "End Sub" lines, enter:
Me.Requery

Haven't tested, but would expect that to work.

 

[SeanH77]

That worked!
Thanks Allen!

What happens if you requery the form in its AfterInsert event?

1. Set the form's AfterInsert property to:
[Event Procedure]

2. Click the Build button (...) beside this.
Access opens the code window.

3. Between the "Private Sub..." and "End Sub" lines, enter:
Me.Requery

Haven't tested, but would expect that to work.

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

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

Once the form is completed and they click or move to a new entry, I need
to
hide the previous entry. The form is set to Data Entry: Yes, but that
only
hides records from a previous session, we don't want to have to close the
Form and re-open it after each record entry. Any/all help is appreciated!
Sean