Append query Qest

[loneranger27]

Hi,

I have an append query that searches and gets a group of records that match a user entered id field. Then it moves these records to a backup table. This works fine. Now I want to move the records back to the original table with a different Id field. I want the Id field to match the value That is used in the current open form. How can I make the query enter into the unitid field the value that appears on the form.

any help is appreciated.
Thanks

 

[dhookom]

You can create a new column in the query
NewID: Forms!frmYourForm!txtYourTextBox

Duane
MS Access MVP
Find out how to get great answers faq219-2884.