Access 2000 Validation Problem

[Ken]

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.

 

[Allen Browne]

Create a relationship between your table and the reference table, with
referential integrity.

Access then maintains the relationship through inserts, edits, and deletes.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

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.

 

[Ken]

Thank you, Allen...we'll give it a go.