Default values in Access

Discussion in 'Computer Support' started by drewrcmusic, May 17, 2007.

  1. drewrcmusic

    drewrcmusic Guest


    Is it possible to make a default value in Access replicated from
    another record?

    I have a user enter a date in one field, but then further along (in
    the same record) I want the date they just typed in to be replicated
    in another field plus 5 days (they have 5 days to complete the
    record). Is this possible?


    - Drew R. Curtis
    drewrcmusic, May 17, 2007
    1. Advertisements

  2. drewrcmusic

    Keme Guest

    Been a while since I did it in MS Access, but IIRC this can be done
    through an "on exit" action on the source field, or "on selection"
    action on the target field. = ...source+5
    Keme, May 17, 2007
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.