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.