Question Archiving

[ipwn]

Currently I have a customer form where it lists the customers on the right handside as a list box.

I fill in the details on the left handside and then click save and it appears on the right.

Now I want to create an append query where I can move these details into the archive table.

How do I go about creating the query so that when I click on a specific name in the list, it archives ONLY that customers details and no one elses?

Thanks alot

 

[pbaldy]

You would add a criteria to the query that points to the listbox, so it only affects that record (presuming the listbox is not multiselect). That said, you generally don't need to archive records; just include a field for their status. That lets you easily get current, old or both.

 

[ipwn]

What do I need to type in the criteria box in the append query if i want to single handedly select records from the lsit ?

 

[pbaldy]

Right click in the criteria box, choose Build, and navigate to the form control containing the key value.