Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

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.

    :-)

  • 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/
Still have questions? Get your answers by asking now.