Guideness please!

[Mitsuki]

Hi

I just want to know how to do it ...

I have a form (ALL ITEMS) where I want to move the record from it to another .. in the form I have a check box + a button which opens another form (History) this form should automatically take the primary key form (ALL ITEMS) form and place in the form (HISTORY) when this happens the record should be deleted from (ALL ITEMS) and saved in (HISTORY)


I just need guidence please!

 

[ansentry]

In normal everyday use of access you should not delete data you should just flag it show that it does not appear with day to day data.

Let say you have records in your table All Items that you are "finished" with and don't want them display using the All Items form. You only want them to appear when you open the History form. All we have to do is put a check box in the All Item table.

Have a look at my example.

Open the form frmCusGeneric and scroll through the records, read the caption at the top of the form and the text to the left of the check box.

Customer list is a list of all Customers not archived
Historiy list is a list of all customers that have been archived.

Hope this helps

 

[Mitsuki]

Thank you
This gave the feel of the idea ..


I have a question now I have a check box on the form "Send to site" now I did a macro that when the box is checked it opens the "History" Table now when the table opens all the items which are checked to be sent to site must be there plus the recently checked one and in the All Items table it shouldnt be there because sometimes the same item No is entered and we dont want duplicates ...


Am I sounding strange ?? Or can you get my point??

 

[ansentry]

can you get my point

Sorry, I don't understand what you mean

 

[GaryPanic]

possile solution

I think I kno where you are going on this one
you need your main form/table you also need a history table
with the key id number being the refernce so if you have 20 items on the main form it will copy them into the history table

unique id
clientname
etc
item1
item2
item3
etc

then have an update query to pend this information into your history table
build you button using the wizard

so when you click the button it appends the info onto the history table
you can if you wish tweak the sytem to delete what you have jsut append to the main table -however I would not recommend this route -better to just let it sit in the foreground

not the greatest answer - but it might point you in the right direction