Recent content by andyg75

i got over it and used the VB code. here's what ended up working: Forms!NewForm.FieldToCopyTo.Value = Forms!OldForm.FieldToCopyFrom.Value thanks much for your help!

that is the sort of complexity i was trying to avoid. is there no way using a macro to select the text in a specific field and copy it to the clipboard?

so the syntax for the left side of the equation is: Forms!NewFormName.FieldNameToBeSet.Value and the syntax for the right side is: Me.OriginalFormName.FieldNameToBeCopiedFrom I get this error: Compile Error: Method or data member not found. the script debugger comes up and the...

Thanks immensely for your help and advice. I know VBA is the way to go in the long run but I'm like one step of getting this working and i just wanted to have it done so I could show the folks in my department how it's going to work... That all makes sense except for line 3. I'm not sure which...

Here's what I would like my macro to do: 1. Select and copy the text in a particular field in the active form 2. Open another form 3. Create a new record 4. Paste the copied text into a field in the new form Everything except step one seems to be fairly easy/straightforward. However, I cannot...