I use [Ctrl + ' ] to duplicate the value in my previous record. This however does not work when I am using a subform (even though it works on the main form). Any ideas why?
Competent Performer
Windows 10 
Access 2016
I use [Ctrl + ' ] to duplicate the value in my previous record. This however does not work when I am using a subform (even though it works on the main form). Any ideas why?
VIP
Windows 10 Access 2010 32bit
Learned something new - never know about [Ctrl + ' ]. Tested with my subform and it works.
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.
Competent Performer
Windows 10 Access 2016
I was playing around with it, and I think it may have something to do with the fact that my subform uses a SharedKey (Dual Primary Key / i forgot the name).
When I add a record in my subform that is linked to the same ID Number, pressing Ctrl+' works. But it wont get any information is the value in the last record was from the previous ID Number.
VIP
Windows 10 Access 2010 32bit
Don't know what a 'Shared Key' or 'Dual Primary Key' are. I am familiar with Compound/Composite Key.
If you want to provide db for analysis, follow instructions at bottom of my post.
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.
Posting Permissions
Reply With Quote