Results 1 to 4 of 4
  1. #1
    Kimberly42506 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Posts
    8

    Talking Copy a cell value

    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?

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    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.

  3. #3
    Kimberly42506 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2011
    Posts
    8
    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?

  4. #4
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    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).

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 11-29-2011, 05:26 PM
  2. Turning a cell red
    By Sharong in forum Access
    Replies: 3
    Last Post: 09-28-2011, 01:51 PM
  3. paste a table into a cell
    By georgenet in forum Import/Export Data
    Replies: 3
    Last Post: 05-20-2011, 01:53 PM
  4. change cell color
    By bishop743 in forum Programming
    Replies: 0
    Last Post: 02-01-2009, 11:00 AM
  5. Can we post Access cell data to Excel cell properties?
    By Zethro in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2005, 08:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums