Search results

Hmmm, I've used the wizard, but I don't see an option to automatically generate a report. What I want to do is make the report generate automatically every time the query runs. How can I do this?

This should be simple, but I can't figure out how to do it. I created a form-based query. The query works fine. But what I want it to do is automatically create/open a report based on the query. How can I do this?

My problem is solved! Thanks DocMan.

Thanks for your response, Doc Man. I'm not entirely clear what you're saying here, but I guess I should mention something I didn't say in my first post: the combo box's record source is a table called 'tblTeams'. So my form falls under your first category here. Your suggestion about using a...

I posted earlier about a similar problem and got some useful help, so I thought I'd try this one here too. I'm a beginner, so please be gentle. I have a very simple form-based query set up. The form is called 'frmTeams', and the query is called 'qryOpenTagsByTeam'. The form has a single...

Thanks neileg and pbaldy for your quick replies. I've done what you've suggested. But the query isn't working properly. In order to get the form to open the query I added this to After Update Events of the combo box: Private Sub cboTeam_AfterUpdate() DoCmd.OpenQuery "qryOpenTagsByTeam"...

This is a very simple question, I think. And I'm very much a beginner at Access. But can somebody help me set up a parameter query where the prompt allows the user to only choose from a few select options, rather than having the user enter the information manually? Basically, I want the query...