Access Form Command Button

imported_Anonymous · Feb 15th 2003

In Access how can I attach the keystrokes Ctrl-' ,used to copy information
from a previous record, to a Command Button on the form.
Just wondering...

greid

smozgur · Feb 15th 2003

This may help :

ControlName is the control name of that field on form.

Code

Private Sub Command1_Click()
    Me.ControlName.SetFocus
    SendKeys "^+{2}", True
End Sub

Regards.

imported_Anonymous · Feb 16th 2003

Thank you very much.
What are the keystrokes "^+{2}" Ctrl-Shift-2 ?
I changed them to "^{'}" , Ctrl-Aposthrophe

And it works great.
Thank you again

smozgur · Feb 16th 2003

Quote

Originally posted by Anonymous
Thank you very much.
What are the keystrokes "^+{2}" Ctrl-Shift-2 ?
I changed them to "^{'}" , Ctrl-Aposthrophe

And it works great.
Thank you again

Yep, "^+{2}" = Ctrl-Shift-2 and your one is the same and better for reading.

You're welcome.

Access Form Command Button

Participate now!

Share