I have (what I hope is) a simple question. I am currently trying to find a way in access 2007 to set my "Default Value" of a cell to be equal to a specific cell in the same row.
example:
entry number name DoB consumer number
1 Kimberly 12/24/2002 1
2 Nicole 10/8/2009 2
3 Michael 4/28/1965 3
what I need is consumer number to be equal to the entry number, both are hidden fields only used for querying and tying tables together, so its not practical to unhide them and have someone type in the next available number. Does this make sense what I am asking?