Access 2000 Validation Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.

Ken said:
I'm trying to restrict the data entered into a numeric form field to
Click to expand...
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.
 
Back
Top