Clear Records

[Guest]

Is there any way to just clear records but not delete

 

[Allen Browne]

You want to remove the records from a form, without deleting them from a
table?

You could do that by setting the form's DataEntry property to Yes, or by
opening it in add mode:
DoCmd.OpenForm "Form1", DataMode:=acFormAdd

Another alternative would be to use a filter that evaluates to False for all
records, e.g.:
Me.Filter = "(False)"
Me.FilterOn = True

Or perhaps you just need to move to the new record:
RunCommand acCmdRecordsGoToNew

 

[Guest]

Thank you very much your answer was very simple & to the point, Sir I have
two more questions with subjects "Report Criteria" & "Sub Form" Please if you
could give me the answer of these questions thanks once again.

 

[Allen Browne]

Each person selects the questions they think they can answer well, so
hopefully you will get good replies to your other questions too.