validation rule or vba

[tubar]

Sorry for my lack of terms…

I have a table “purchases” that contains a lookup field. The lookup field displays the field “upc” from the table “red”. “id” is the primary field in the table “red”.

The lookfield “upc” should only be able to except the values greater then 10 but less than 100. Do I come up with a validation rule for this field in this table? If so what is it? Or is a form with vba the way to go…and if so what is the vba?

Thanks for the help

 

[jdraw]

Sounds like an input data entry form with some logic.

You say a table purchases, but I think you'd have a table of Products as well...

 

[tubar]

yes there is a lookup feild "items" which originates from the products table

 

[RuralGuy]

Here's a link to read: http://access.mvps.org/access/lookupfields.htm

 

[tubar]

thankyou...this will help a great deal!!

 

[RuralGuy]

Those Lookup Fields can drive anyone nuts.