Hi Jason -- I got this working, but i found I have another challenge to overcome before I can check it.
I need to include a brandID in the data for the Insert Record. The brandID is available in both the brands table and the products table (from current product records). I expect the best way to determine the proper brandID for the brand of the product being added is to query either the brands or the products table for the brandID where the brandName = the brandName from the form. However the code for the attached page inserts a (NULL) in the brandID column.
How can I extract the right brandID and add it to the Insert code?? I have excluded the recordset filtering code for now. . .
Thanks