coding a combobox afterupdate event

[jminn0311]

I need some help coding a combobox to compare against a query to see if the date of the combobox selection is 365days more than the maxdate of of the same combobox selection in the table.

I have the query that produces the maxdate for each episode of the combobox selection. Now I need help coding the afterupdate event to compare the combobox selection's date on the form against the maxdate value of the query. I will make an attempt to show you what I am trying to accomplish.

Query
Field1 Field2
Dog 12/5/04
Cat 12/5/02

Form
ComboBox DateBox
If I select

Cat 1/12/05

I need to know if it has been more than 365 days since I last selected cat.

Does anyone have any ideas on how to accomplish this?

Thank you in advance for help and replies

Jeff

 

[DoubleD]

If Nz(DMax("Field2","QueryName","[Field1] = '" & Me.ComboBox1 & "'"),#1/1/1900#) > (Me.ComboBox2 - 365) Then
' What do you want to do?
Else
' What don't you want to do?
End If

I am what I am based on the decisions I have made.

DoubleD