Post changed form info to a different table

[almgraph]

How do I set up a form so that when a record is retrieved and changed that it will automatically post the record data to an second table and not the original table from which the record was retrieved???

 

[DougP]

One way to do this is have unbound text boxes.
If the box is bound you cannot do anything different.

Then you will have to create a search routine to find the record and place it in the text boxes.
The User edits the data, then have a Save button to save it back to the second table.

That's a lot of work though.

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.