Removing records from a form

[Guest]

Hi

I have a form with about 20'000 records on. What i would like to do is
clear some of these records as we do not need to keep them on the form any
longer. I dont want to delete them permanently though, i would still like
them to be kept on the table that it relates to.

Is there any easy way to do this please?

Thanks as always for your help

 

[Allen Browne]

Just add a field to your table.
Name: Inactive
Data Type: Yes/No

Set the RecordSource of your form to a query that excludes the inactive
records, i.e.:
WHERE Inactive = FALSE

We do that all the time. If you really need to move them to another table,
see:
Archive: Move records to another table
at:
http://members.iinet.net.au/~allenbrowne/ser-37.html

 

[Guest]

Thanks Allen

Perfect!

xx

Just add a field to your table.
Name: Inactive
Data Type: Yes/No

Set the RecordSource of your form to a query that excludes the inactive
records, i.e.:
WHERE Inactive = FALSE

We do that all the time. If you really need to move them to another table,
see:
Archive: Move records to another table
at:
http://members.iinet.net.au/~allenbrowne/ser-37.html

 

[Guest]

Hi Allen

Im having a bit of a problem with this! (as normal!!! ). Ive added a
field to my table. Now the bit ive got a problem with is the query bit and
changing the record sorce of the form. Ive already got a recordsource set for
the form and im thinking it might mess up the form.

Ive added a chq box to another form that ive got that i did based around a
query. However the form that im trying to change is based on the table.

Sorry to be a pain, im getting all confused now!

 

[Allen Browne]

You've already set up the query, and now you need to make your form read the
query instead of the table?

1. Open your form in design view.

2. Open the Properties box (View menu).

3. Make sure the title bar of the Properties box reads "Form", i.e. you are
looking at the properties of the form, not those of a control.

4. On the Data tab of the Properties box, change the RecordSource property
from the name of your table to the name of your query.