Ninamashr Posted January 5, 2009 Posted January 5, 2009 Is there a way for the Auto-enter data in a field be overridden by the data that was entered when the record was duplicated? For example field "A" has "n/a" as being auto-entered upon creation, I change field "A" to say "b/a", I then duplicate the record, but in the new record, field "A" reverts back to "n/a" instead of staying as "b/a".
mr_vodka Posted January 5, 2009 Posted January 5, 2009 Try Case ( IsEmpty ( YourField ); "N/A"; YourField )
Ninamashr Posted January 5, 2009 Author Posted January 5, 2009 So just change the field from auto-enter data to a straight calculation. Thank you very much Mr-Vodka, I really appreciate it!
mr_vodka Posted January 5, 2009 Posted January 5, 2009 No. you can use a auto-entry with calculated value.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now