troubleshooting Question

AutoFillNewRecord

Avatar of BuddyKing
BuddyKing asked on
Microsoft Access
10 Comments1 Solution469 ViewsLast Modified:
I have had occassion to attempt using this function many times during the last fifteen years, I always try it, I always think I will be able to now figure out the mistake(s) I have made in the past, and it never works. Well, it works, but not the way I want it to. I want to copy one field from the last record, not the entire record. I understand the test box on the form, name it correctly but I think I get something wrong in the "Default" part. I go to the text box properties/Data/Default Value and have tried (ATTENDED is the name of the field I want to copy) and have tried Attended (then "Attended" appears), = Attended, [Attended], = [Attended], I have included the path....I have tried everything that I think might be meant in the instructions, but there is something that I am not getting. All fields are filled which cause a problem with primary key duplications and fields that I don't want. I know this has to be a basic misunderstanding on my part, but I would appreciate it if somebody could point it out. Thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros