D
dancollette
Hi,
It's been 2 years I haven't touched VBA and Access... OUCH
I have a problem...
I have a reference table (Products) that lists all the products with the
following fields: Product_no, Product_description, Category, Subcategory.
When I upload orders in my database i compare the Product_no against the
reference table and I want to identify all the products on the invoice that
are not in my reference table. I can do that with an SQL statement and load it
into a recordset....no problem so far.
Where i need some help is that i want to return the new items that are not
into my reference table into a form where an end-user can update the Category
and Subcategory (which are lookup fields) fields and then update the reference
table Products.
Thank you.
Daniel
[email protected]
It's been 2 years I haven't touched VBA and Access... OUCH
I have a problem...
I have a reference table (Products) that lists all the products with the
following fields: Product_no, Product_description, Category, Subcategory.
When I upload orders in my database i compare the Product_no against the
reference table and I want to identify all the products on the invoice that
are not in my reference table. I can do that with an SQL statement and load it
into a recordset....no problem so far.
Where i need some help is that i want to return the new items that are not
into my reference table into a form where an end-user can update the Category
and Subcategory (which are lookup fields) fields and then update the reference
table Products.
Thank you.
Daniel
[email protected]