Validate a field from a recordset
I have an insert page to insert a 'product'. A Supplier cannot insert a product without a valid supplier number. I wish to validate the first field on my insert page - 'Supplier Number' by looking up a (Suppliers) recordset.
I know I could use a drop down list and popluate it from the recordset, but I dont wish to do this.
I want to be able to add some kind of behaviour - on blur - to lookup the suppliers recordset and display a message if not a valid supplier.
Or is there a better way to do this?