Access Table Validation Help!!

[ahpitre]

You could redesign your Cost table. Make your serial number a lookup field. Use the Revenue table as the source to look up. Finally, restrict Lookup values to only those from the lookup table (this will not allow to enter anything that is not in the related Revenue table). Basically your creating a relationship between both tables, and enforcing it via the table's design. This way, whenever you drag'n drop the serial number onto a form, a combo box is generated aut. (without having to do any VBA code)..

Notes : You might get a warning when saving your changes to the Cost table, this might occur if there is data in the Cost table whose serial num. is not present in the Revenue table. Ignore these warnings. Changes should save OK, and validation will take place for new records, not for existing records.