automated transfer of data between tables

[Michelle]

Do you know how to refresh the data in the tables once you have executed an
append/delete macro without having to close it down?

I have set up an append/delete query that should take information from the
HR table when the completed box is ticked, move it to the achieve table and
delete it from the HR table.

Another one will work the opposite way - take a reopened record i.e. take a
record with an unchecked completed box from the achieve table back to the
original table and delete it from the achieve table.

The macro will run from the button, sort of, at first it says that no
records are being appended and no records are being deleted. When you close
the DB and reopen it again it then click the archive button it re-runs the
macro it will then identify records to be appended and deleted them - but we
also get the text #deleted# in every text box on the form. Then you have to
re-close and reopen the DB again before you can see the changes.

Surely there must be an easier option to perform the move, the delete, the
update and refresh the database in one easy step.

I am very new to this type of database design. Can this be added onto the
macro or does code need to be written although I have no idea about VB code.

Can some help with a bit of a step by step guide it will be much appreciated.

 

[Klatuu]

Where are you showing the records? If in a form, just requery the form

 

[Michelle]

The completed records are deleted from the HR table and moved therefore shown
in the archieved table.
The reopened case notes in the archieved table are moved and deleted from
the retrieved table and shown back in the HR table.

 

[Klatuu]

Sorry, that doesn't answer my question.
When you append data to a table it is immediately there, So I don't
understand what it is you want to do.

 

[Michelle]

Sorry, that doesn't answer my question.
When you append data to a table it is immediately there, So I don't
understand what it is you want to do.

 

[Michelle]

Thats what i thought it should do but for some reason it doesn't do it
immediately.
You get a dialogue box that says its appending 0 records and deleting 0
records. It only moves the records when I close the database down and reopen
it. But i want it to happen straight away it this possible? If not do I
have to add update automatically or refresh in order for it to do it straight
away. if so how do i do this?
There are no forms involved.
Sorry obviously not very good at explaining my self but thank you for
replying

 

[Michelle]

I assigned a command button but am i using the correct macro action to it - i
am using open query - append and open query - delete to run directly
afterwards. Do I need to add anything else for it to run automaticlly?