Subform which pulls value

[JerryJay]

I have a Subform which pulls a PayPeriod Date from a Table. The user populates the Pay period from a drop down list.

I would like to restrict the user from using the pay period date more than once. Example If I choose 1-1-08 thru 1-7-08. I do not wish for the individual to have the ability to choose 1-1-08 thru 1-7-08 again.

 

[PHV]

Have a look at the DLookUp function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya JerryJay . . .

If the combobox is [blue]unbound[/blue], you can exclude the selection from the list with a [blue]WHERE[/blue] clause! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886