10 pts.
 How to create a Microsoft Access form that generates a spreadsheet with parametered values?
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

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _