Need to hide previous Form entries

  • Thread starter Thread starter SeanH77
  • Start date Start date
S

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
 
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.
 
That worked!
Thanks Allen!

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

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