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

Question

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

Answer 1

Try the link listed below. I hope that helps.

:-)

Answer 2

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! :)