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
 

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

validation rule problem 1
validation rule 2
Creating a Search using a combo box and then creating a report. 4
Creating a Chart on form from selected data in query. 0
Lookup value in a query and display it in a text box on a form 6
Setting a default zoom in Infopath 0
Data look up 1
Message Box on Duplicate Entry 1

Top