AutoKey Macro for CTRL + '

[desireemm]

Hello I need to create an Autokey macro but not sure how to do it. its
suppose to Insert the data from the same field in the previous record CTRL+'
can anyone help please

 

[June7]

Try something like:
DoCmd.RunCommand acCmdRecordsGoToPrevious
varData = fieldname
DoCmd.RunCommand acCmdRecordsGoToNext
fieldname = varDat

 

[Steve Schapel]

Desiree,

I am struggling to understand. You are apparently already aware of Access's
built-in Ctrl+' keyboard shortcut for this purpose. And now you want to use
AutoKeys to create another keyboard shortcut to do the same thing? Why?
What's wrong with using Ctrl+' and what advantage would it be to use
something else instead? You still tie up the same number of fingers!

 

[desireemm]

The reason is because I am using an ADP and it does not support CTRL +
Apostrophe only an MDB does. but I have SQL Server 2005 as the engine

 

[desireemm]

I was told to use this but I'm not sure how do I put this in the afterupdate
of the form properties . and is the control name the name of the subform??
Private Sub YourControlName_AfterUpdate()
Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub

 

[desireemm]

I wanted to do this in the subform is this correct I put it in the
properties Afterupdate()
Private Sub Tanf_tblsubform_AfterUpdate()
Me.Tanf_tblsubform.DefaultValue = """" & Me.Tanf_tblsubform.Value & """"
End Sub

 

[desireemm]

Private Sub Tanf_tblsubform_AfterUpdate()
Me.Tanf_tblsubform.DefaultValue = """" & Me.Tanf_tblsubform.Value & """"
End Sub

ok here is what I got, now do I put the field names in there because they
would be inputing hours into the subform. do I put the field names where the
quotes are. [Catagory for hours] [Services Covered], [Earned hours] [contact
date] [purpose of contact]??