You need to find out what code is behind the command button that archives the
records.
1) From the form's Design View:
2) Right Click on the button
3) Make a note of the command button's name
4) Select Properties
5) Click on the Event Tab in the Properties box
6) You'll see "On Click"
7) In the box to the right you should see "Event Proceedure"
8) Left Click to the right of this entry
9) This should bring up an ellipsis (...) Double click on this
This should take you to the code window and you should see a sub listed for
the command button control something like "Private Sub
CommandButtonName_Click()" where CommandButtonName is the actual name of the
button you noted in step # 3 above
You need to copy this sub and post it here so that I or someone else to try
to figure out where the records went to. They may have been placed in a
separate table, or could even be in the same table where your active records
are; sometimes we don't actually move the records but merely use a checkbox
to denote an "active" versus an "inactive" record. If it's marked "active" it
appears in the form's underlying query and thus shows in the form. If it's
marked "inactive" it's not retrieved by the query and ths doesn't show up.
BTW, since you're new to all this, please understand that we're all
volunteers here. We're happy to help, that's why we troll these waters, but
we tend to come and go as other duties call. I'll check back when I get a
chance, and others will probably have a look and help if they can.
--
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200702/1