I want to have a button on a form to Duplicate a record. Not all of the fields would be duplicated. The code works until I use the fields that are Lookup Fields. I am not sure how to type the names of the fields to reference the correct field name. In the code, the Region, Class and Seller all come from a Lookup. My code is as follows:
Code:
Private Sub DuplicateRecord_Click()
With Me.RecordsetClone
.AddNew
Create a script to change first three words of text to uppercase
I want to use an AfterUpdate Event to change the first three words in an Access text field to uppercase. I need suggestions on the correct syntax for the script. thank you.
Leave a comment: