I have an ordering form that use two combo boxes to filter down the
records of a Products table. This worked fine with the after_Update of
the first filtering the records and creating the rowsource of the
second combo. The second combo's control source is the Product ID field
(foriegn key) on the Orders table.
Everything worked well until I decided to enhance the form by changing
the second combo to an option group. Now I don't know how to use both
of the controls to filter down the Products table records to get the
appropriate record (ID field - Primary key) and insert it into the
Product ID field (foreign key) of the Orders table.
I have created a properly working SQL INSERT INTO / SELECT statement
that gets the right data but can't get it to insert it into the table.
As an alternative I created a select query that works properly but
don't know how to get the output of the query into the table. I guess
it's a similar problem.
Any help would be appreciated.