promotion image of download ymail app
Promoted

In Microsoft Access, how can I set the 'Default Value' by adding other column value?

Is that using comman

DateAdd("y",+28,[Member_Registeration].[Registeration_Date])

Member_Registeration is a table that contain Registeration_Date column.

but that is a runtime error.

Can any body help me.Thanks

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Try the link listed below. I hope that helps.

    :-)

    • Commenter avatarLogin to reply the answers
  • 1 decade ago

    I wouldn't set the default value field. Instead use your function in the text field on the form. The table will be updated when a date is entered in the corresponding text box.

    If that doesn't work, then please check the link I give below for help from other Access database programmers.

    Hope that helps. Good luck! :)

    Source(s): Microsoft Access Forum: http://www.utteraccess.com
    • Commenter avatarLogin to reply the answers
Still have questions? Get your answers by asking now.