Access 2000 Validation Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ken (websterK_at_kpgraphics.com)
Date: 02/24/04 

Date: Mon, 23 Feb 2004 21:26:06 -0800

I'm trying to restrict the data entered into a numeric form field to values contained in either a subform or another reference table within the database. That is, if the numeric data entered equals a value in the reference table, it will be accepted. If not, a validation error will occur. I'm assuming that I need to develop a VB comparison, but I'm not familiar with the mechanism or code to accomplish. A full example would be greatly appreciated.