Hi.



As i tried it seemed to me that it is useless to update a combo box who's control source is attached with an autonumber field.

But i design another database.

which include three tables.
Category
Prudocts
and Order Details

i Create a Form: Products and placed a button find products
which open another unbound form"Find Product"
here two combo box and one button.

After selecting category and product from list,
i want that when we click on button then it will update the products form and its subform order details.


can it is possible.
thank you for your help in anticipation