After Update Field Populate Another Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, does this need programming? I want a field to be populated after updating
it with a Date. For example, FieldInitialDate and FieldEndDate. This 2 dates
should be the same, but sometimes will be different. Also, have a check on
the FieldEndDate to make sure that date is not before the FieldInitialDate.

Thanks
 
Hi, does this need programming? I want a field to be populated after updating
it with a Date. For example, FieldInitialDate and FieldEndDate. This 2 dates
should be the same, but sometimes will be different.
Click to expand...

Use the AfterUpdate event of FieldInitialDate to "push" the entered value into
FieldEndDate:

Private Sub FieldInitialDate_AfterUpdate()
If IsNull(Me!FieldEndDate) Then ' don't stomp on existing data
Me!FieldEndDate = Me!FieldInitialDate
End If
End Sub
Also, have a check on
the FieldEndDate to make sure that date is not before the FieldInitialDate.
Click to expand...

Check in the Form's BeforeUpdate event, and cancel that event if it's not.

John W. Vinson [MVP]
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working with date fields in a form 2
error on update table WHERE date comparison 0
Problem getting dates to enter a date field correctly 1
How do I populate current date based on another fields output? 1
Automatically update an AmendDate field on my form using VBA 1
Module that caculates the difference between times 1
Populate subform field on Afterupdate of main form field 6
Date woes using VBA 3

Back
Top