access data validation conundrum

i am trying construct a field data validation in an access 2000 form where it validates that a typed in part number is a valid part number.. i have the valid part numbers in a seperate table but have not found the correct syntax yet to have what is typed in the field validate against the valid parts table..