J
Joshua
Hello,
I have a sales analysis form. The form has 2
combos: one for choosing the product and the other for
choosing the financial quarter in which the performance of
the product is to be analysed.
Due to the large database and the 'sum', 'AVG' functions,
I am using in the query, it takes long time for the combos
to list values.
So, I want to replace the Products with a Text box or
something that gets input form the user(that is the user
types in the product name) and then choose the quarter
from the second combo.
I dont know how to receive user input and according to
that, requery the second combo(with the financial
quarters) and create the form.
Since I am new to Access, please pen your responses
accordingly.
Thanks
Joshua
I have a sales analysis form. The form has 2
combos: one for choosing the product and the other for
choosing the financial quarter in which the performance of
the product is to be analysed.
Due to the large database and the 'sum', 'AVG' functions,
I am using in the query, it takes long time for the combos
to list values.
So, I want to replace the Products with a Text box or
something that gets input form the user(that is the user
types in the product name) and then choose the quarter
from the second combo.
I dont know how to receive user input and according to
that, requery the second combo(with the financial
quarters) and create the form.
Since I am new to Access, please pen your responses
accordingly.
Thanks
Joshua