Post changed form info to a different table
Post changed form info to a different table
(OP)
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???
RE: Post changed form info to a different table
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.