Access Forms – How to set field default value = to another field on form

Topic

New Reply

I have a form that I use to update a table. The form is used to record details of activities that generally start and finish on the same day, but not always. Accordingly I have two fields on my form: Start_Date and Finish_Date, and I would like Finish_Date to be automatically populated and only changed if the activity runs beyond the day it started.

I would like to be able to set the Default Value for Finish_Date equal to the value entered in the Start_Date field and have tried setting the default value to =[Start_Date], but nothing happens.

I’m guessing the solution is simple, but I just can’t find it. Any help will be much appreciated.

Reply | Quote

Replies

Use the AfterUpdate event of the Start_Date field to set the value of Finish_Date.

Code:

Private Sub Start_Date_AfterUpdate()
   If Not ISNULL(Me.Start_Date)  Then
     Me.Finish_Date = Me.Start_Date
   End if
End

You may want to do additional testing to see if Finish_Date already has a value and then act accordingly.:cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Many thanks RetiredGeek, just the solution I needed:clapping:

Reply | Quote

I am also learning VBA for MS Access.
this helps my learning.
Thanks!

Reply | Quote