If statement?..

[BT24]

Hello

I have a form and i would like to make it so when a Truck # and a date are entered that that is the only time that it can be entered for that truck and that date. The truck number field is based on a query and the date is used with Now(). if you can help me it would be greatly appriciated.

BT24

 

[jebry]

Hi!

You can create an index using these two fields and set the index' unique property to yes.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[BT24]

Wow thanks, i must have had a brain cramp yesterday. sorry for wasting your time

Bt24