Default values in Access

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

  1. drewrcmusic

    drewrcmusic Guest

    Hi.

    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?

    Thanks,

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

  2. drewrcmusic

    Keme Guest

    skrev:
    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.

    ....target = ...source+5
     
    Keme, May 17, 2007
    #2
    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.