How to create a Microsoft Access form that generates a spreadsheet with parametered values?

10 pts.
Tags:
Microsoft Access ComboBox
Microsoft Access forms
Microsoft Access import/export
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following