I need a (event) button on the main form to open a form in ms access, the combination alt R has to be automatically entered and the form needs to close after the data has bean .
The combination keys "alt r" is needed to read data from the barcode reader.
After reading the data in the opend form another subform on the main form needs to reload because the data that is entered needs to show the new data.
I have the code for the On click event but th code for the shortkey and reloading the suborm is missing
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Offer"
DoCmd.OpenForm BarcodeDataForm, , , stLinkCriteria
DoCmd.Close acForm, BarcodeDataForm
I have found custom MySendkeys
But don't know how to use it.