CTRL +' Short Cut Key

[desireemm1]

HI I need to create a macro that does the same thing as the CTRL +' key which Insert the data from the same field in the previous recordCTRL+'can anyone help pls

[RuralGuy]

Maybe this link will be useful.

[desireemm1]

Hi guys I have a question, How do I carry forward the current value of a control so that it's automatically entered for all new records. I'm still trying to work on this issue, found this on a website, just trying to make sure I'm coding this correctly. It says to carry the current value of the control forward if you place this code behind a command button to conditionally run it. Now I have about 5 fields that I would need to run this on (hope I'm saying that correctly). Not sure how I would implement that. Can some one help please


const cQuote=""""
me!Earned_hours.DefaultValue = cQuote & me!Earned_hours.Value & cQuote