In this simple macro, exploring the behaviour of Go To Control and SendKeys in a Cat Record Database, the execution of all or part of the macro appears to be inhibited after saving and executing the macro. Does this mean only one control can be included in the macro?
CatName is the name of a field on the form of (say Record 1) which holds the cat's name. (CatName is a column in the database spreadsheet)
ClinicalNotes is the name of a field on the form Record 1 where the cat's name (CatName) can be pasted. (ClinicalNotes is a column in the same database spreadsheet as CatName)
The macro is set out like this:-
Go To Control CatName Targets the CatName Field
SendKeys (^c) Copies the contents of the field to the MS Access and Windows clipboards.
Go To Control ClinicalNotes Targets the ClinicalNotes Field
SendKeys (^v) Pastes the contents into the ClinicalNotes field.