Help with combo boxes to make reports.

[PuddinPie]

Hello,

I’m kind of new to Access 97 so please bear with me.

I have a form with four combo boxes linked to a union query. It’s a start date, end date, User, and system

What I am trying to do is, by there selections in the combo boxes I want to use the query to populate a report with the matching information.

All the combo boxes are populating with the correct information I just need to know the proper VB coding for the submit button.

Thank you.

[jimatqsi]

Before we try to spell it out for you, guessing your field names and such, try using the button wizard to see how close you can get. When you add a button to your form, one of the wizard options is to launch a report.

The wizard leads you through the process to do exactly what you want.

Actually I don't remember well what is in Access 97, so I could be wrong for that version. If necessary, you might try loading Access 2000 or 2003 and do the same thing, then if you must work in 97, just apply the same code; you can probably even copy and paste the code from 2000/2003 to 97.

Jim

[NeoPa]

That's good advice from Jim. If you want an understanding of how it works though, have a look at Example Filtering on a Form.

Welcome to Bytes!

[PuddinPie]

Thank's. That helps.