A
Abdul Shakeel
Is there any way to just clear records but not delete
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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
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
A
Abdul Shakeel
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.
two more questions with subjects "Report Criteria" & "Sub Form" Please if you
could give me the answer of these questions thanks once again.
A
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.
hopefully you will get good replies to your other questions too.