Validation Rule Problem

D

Deepak

Hi all

I have a query where i have calculated the two acceptable dates. e.g. A1 and
A2

Now I have made a form and asking the user to enter a date for particular
policy.

On the form itself, i have made a validation rule restricting on the propery
sheet like this
=DLookUp("[A1]","[Acceptable Dates]","[Policy Number]=" & [Forms]![Premium Paid]![Policy No]) And <= DLookUp("[A2]","[Acceptable Dates]","[Policy Number]=" & [Forms]![Premium Paid]![Policy No])
Click to expand...

where is acceptable dates is the query from where A1 and A2 values are
picked up for a particular policy and Premium Paid is the form

The problem is that i m not able to select the value in between those dates

Kindly help me, where i am going wrong and is there any other way of doing it.

Thanks
Deepak
 
Top