I want to copy some fields in a row and paste them in next few rows. how to do it instead of pasting in each row by Ctl +v
I want to copy some fields in a row and paste them in next few rows. how to do it instead of pasting in each row by Ctl +v
If you want to repeat values into next record while doing data entry, can use VBA to set DefaultValue property of the controls you want data to carry forward. Must use a form for data entry.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Ditto key = CTL " (you know the ditto symbol = dbl quote)
BTW: CTL : (inserts todays date)