Please Help Me... I'm Melting..
I have a question, (everything I know is self tought so please pardon my ignorance):
I have an unbound form with 4 combo boxes on it. Each combo box refers to it's own query (which basically lists a specific tables fields contents in alpha order). No1 queries a list of product name and groups them so only one of each type will be shown. On selecting a product, it requeries the no2 combo using no1's selection as part of the criteria and so on till you get to no4.
Here's the trickier bit.
After updating number 4, a subform (which is based on a query using the above 4 combo's as the criteria) is requeried and tells you how to perform certain functions on another system. This bit is fine BUT, I want to be able to record in list fashion what instructions have been offered, but each time I go through the selection process, the first line of the subform is requeried instead of moving onto the second or third line..
I know it has something to do with the requerying, but I don't know how to handle this one as it's new to me...
Any help is much appreciated.
Chyld
I have a question, (everything I know is self tought so please pardon my ignorance):
I have an unbound form with 4 combo boxes on it. Each combo box refers to it's own query (which basically lists a specific tables fields contents in alpha order). No1 queries a list of product name and groups them so only one of each type will be shown. On selecting a product, it requeries the no2 combo using no1's selection as part of the criteria and so on till you get to no4.
Here's the trickier bit.
After updating number 4, a subform (which is based on a query using the above 4 combo's as the criteria) is requeried and tells you how to perform certain functions on another system. This bit is fine BUT, I want to be able to record in list fashion what instructions have been offered, but each time I go through the selection process, the first line of the subform is requeried instead of moving onto the second or third line..
I know it has something to do with the requerying, but I don't know how to handle this one as it's new to me...
Any help is much appreciated.
Chyld
