Hace Access Check if data already exists within table. If so, complete form fields.
Posted on 2007-07-26
I have a table that functions as a subtable. This subtable contains a list of chemicals in one product. This table of chemicals have two fields - CAS and NAME. The same CAS always has the same NAME.
I would like to have a subform that allows the user to enter the CAS of each chemical. If the CAS has not been entered in the table before, then the user can enter the NAME. But, if the CAS has been entered before, then I would like it to recognize it and complete the NAME field. Then I would like this to be a new record in the subtable.
This way, the user does not have to retype the NAME (which can be long and difficult to spell) if they have already done so once. Realize that there are other fields within this record, such as "Percent of Chemical" that is unique that one CAS record.
I hope I have explained this clearly.