B
blazerklk
I have a Mainform with two fields named Recording and InstDate. Also, have a
Subform with two fields named Recording and InstDate. The data from these
tables are unrelated.
Without selecting Recording from the Subform and doing it again with the
InstDate and copying and pasting each individually, I would like to select a
record in the Subform by Double Clicking it to copy both fields and set focus
to the record in the Mainform and paste.
Mainform = Ownership Table
Subform = Inst Table (both fields in same recordset here)
Both forms continuous
Recording is Text in both tables (Ex. 399/100)
InstDate is Date in both tables (Ex. 10/7/2007)
Using Access 2003
Could anyone help with this DblClick Event. This could save a lot of time.
Subform with two fields named Recording and InstDate. The data from these
tables are unrelated.
Without selecting Recording from the Subform and doing it again with the
InstDate and copying and pasting each individually, I would like to select a
record in the Subform by Double Clicking it to copy both fields and set focus
to the record in the Mainform and paste.
Mainform = Ownership Table
Subform = Inst Table (both fields in same recordset here)
Both forms continuous
Recording is Text in both tables (Ex. 399/100)
InstDate is Date in both tables (Ex. 10/7/2007)
Using Access 2003
Could anyone help with this DblClick Event. This could save a lot of time.