B
blueman
I am using Access 2002 and want to retrieve some of the values from
the previous record and use them in the same controls in the next
record by pressing a command button while still on the previous
record.
Let me add that I am not a programmer and do this in my spare time.
I've built the databases that I use in my business with macros, not
VBA, which unfortunately I don't have time to learn. Please don't
bother with a VBA answer. I won't understand it. Thanks
I'm guessing it should either be something with a of "Set Value"
action or simply running a "Sendkeys" command using the ^' (Control +
apostrophe)key stroke. Using "Set Value", I'm not sure how to
reference the previous record once the record changes other than just
using the (Control + apostrophe)key stroke. Any help would be
appreciated
Thanks
the previous record and use them in the same controls in the next
record by pressing a command button while still on the previous
record.
Let me add that I am not a programmer and do this in my spare time.
I've built the databases that I use in my business with macros, not
VBA, which unfortunately I don't have time to learn. Please don't
bother with a VBA answer. I won't understand it. Thanks
I'm guessing it should either be something with a of "Set Value"
action or simply running a "Sendkeys" command using the ^' (Control +
apostrophe)key stroke. Using "Set Value", I'm not sure how to
reference the previous record once the record changes other than just
using the (Control + apostrophe)key stroke. Any help would be
appreciated
Thanks