Copy a cell value

[Kimberly42506]

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?

[boblarson]

Pardon if this seems a bit harsh, as it isn't meant to be, but you do not need to have another column which is the same number as you have in the first column. Storing redundant data is not something you want to do in a relational database.

You can link fields which have the same data but different names. There is no need to have them have a field which is the same name.

[Kimberly42506]

I see what you meant, i readjusted a few of the relationships so i no longer needed that field, i guess i was over thinking it originally. now i have a different question if you dont mind, what im creating is a form to fill out, but it seems pressing enter in certain fields, or even tab will clear the form/subform. i have turned Tab Stop off and it still clears the sections, can you tell me if/where I am missing something else?

[boblarson]

It sounds like you may have some unbound controls, but it is hard to say. If you want to upload a copy here, we can take a look. If you do, be sure to run COMPACT AND REPAIR first and then zip the file (you can do that by right clicking on your database file and selecting SEND TO > COMPRESSED FOLDER).