Hey Steve!!! Thanks for quick response.
Here's what I'm trying to do.
I'm setting up intranet and need to have a page with data and a button by each record. When user clics on the button the record is erased from the current table and moved to a different table in a database.
I was trying to set up Data Access Page out of Access (not an Access form), but maybe I need to do it in ASP?
I'm trying to do something similar. I got a form sowing continous records I've got a button on each record to run a append query. The query copys all records to the new table but I only want the one i've selected for the row. In my append query how do i set the criteria to select only the selected row im running the query from . Hope this makes sence.
Here's one option. Have the button on your continuous form open another form (example: frmRecordSelection). This form will have a field (txtRecordToAppend) where the user will enter a unique value (example: Employee ID) from the record that is to be appended. A button on frmRecordSelection can run an append query in which the criteria for the unique value is based on txtRecordToAppend.
I've got it working the problem I was having is that it was a subform and didn't use the correct parent child link to access the relavent field. I've managed to use a append query to move the record to another table an a delete query to remove it form the original table. Now I'm trying to add vb code to refresh the subform but not sure of the correct way to refresh it. If i place a refeash button using the wizard on the subform it doesn't refresh the form but if i place it on the parent form it works. I want to add vb code to my archive command button to refresh the subform how do I do this. I cant seem to get the sytax right for the .refresh command.