Hello,
I have a table that has this type of fields (almost 26,000):
Cia Type Account Type Call flag Country Client code
related main include China 5765
not related auxiliar not include USA 3372
related auxiliar excepted USA 981
related auxiliar include China 789
In access I need to create a Form that using 4 diferents Combo boxes or 4 List boxes, I can select one criteria for each combo box and then generate a datasheet with those fields in it.
For example:
I. in the form I would like to make this selections and generate a datasheet.
Cia Type: related
Account type: auxiliar
Call flag: include
Country: China
RESULT:
Cia Type Account Type Call flag Country Client code
related auxiliar include China 789
then, later taking the same Form I would like to generate another datasheet with all the fields that match these criteria:
Cia Type: related
Account type: auxiliar
Call flag: excepted
Country: USA
RESULTS:
Cia Type Account Type Call flag Country Client code
related auxiliar excepted USA 981
As you can see, each datasheet should be different from the previous, depending on the criteria selected in each Combo box of the Form.
I know how to do this with a simple query, inserting each condition in the "criteria" field, but I am looking to somehow make this a more efficient and automatic process using a Form.
Please I would appreciate if you could help me.
Thanks.
Software/Hardware used:
ASKED:
March 21, 2009 10:35 PM
UPDATED:
March 23, 2009 3:10 PM