how do I compare to date to each other?

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

Guest

I am trying to compare two date to each other. If the are the same then a
text field is loaded in a word. Date0 is on a subform and H_Date is on the
main form. H_date is selected by the user, and if it matches the date of the
day then text4 receives the work test. I am trying to avoid hard coding the
dates because H_date is a group of 12 dates that are changed periodically.
The person doing the changes will not understand out to change the code for
the dates. Any suggestions?

if Date0 = H_Date Then Text4 = "test"

Matt
 
wheelz said:
I am trying to compare two date to each other. If the are the same then a
text field is loaded in a word. Date0 is on a subform and H_Date is on the
main form. H_date is selected by the user, and if it matches the date of the
day then text4 receives the work test. I am trying to avoid hard coding the
dates because H_date is a group of 12 dates that are changed periodically.
The person doing the changes will not understand out to change the code for
the dates. Any suggestions?

if Date0 = H_Date Then Text4 = "test"
Click to expand...


standard subform control reference:

if subformcontrol.Form.Date0 = H_Date Then Text4 = "test"
 
Back
Top