Form/Report process

[pg13Reader]

Hello, I’m having difficulty with form/report process.



Right now I have on the main form a button the user clicks and it opens up a (pop-up) form. On this form they can select from a drop-down list in a combo box it will pull up a report, then closes the pop-up form. The print preview of the report shows up, but once the pop-up form closes the focus goes back to the main form instead of the report. Is there a way to have the focus on the report?

Here’s the VB code – for the combo box, after update/event procedure:

DoCmd.OpenReport "r_ReviewDetail", acViewPreview, , , acWindowNormal
DoCmd.Close acForm, "f_ChooseType", Save

My goal is to have a drop-down menu list of items in order to filter for a report. How this is accomplished, with a pop-up sub-form, or some other way doesn't matter as long as it works. It seemed like this was the only way…. (initially had a prompt with dialog box where the user had to enter information, but that wasn't working well, people type the wrong info. I need them to choose from a list.)

Thanks for the help!!

[June7]

Try:
DoCmd.SelectObject acReport, "YourReportName"

[aytee111]

Instead of using a form, have a list box containing the same values as your combo box. Add the open report code to the Double-click event of the list box.

[pg13Reader]

Try:
DoCmd.SelectObject acReport, "YourReportName"

This worked like a charm! Thank you.

The list box idea sounds good, but if there were additions or deletions to the list, someone (me) would have to modify the list options each time, right? The combo box, while not super elegant at least allows for evolving data.

Thanks again for all the help!!

[June7]

Actually, a listbox has a RowSource just like a combobox and therefore also allows for 'evolving data'. aytee is suggesting put listbox (or combobox) on the main form instead of the button that opens 'popup' form.

[pg13Reader]

I haven't used listboxes too much, the few I do have in my DB have all been done with a list I created instead of pulling from a query or table. Maybe I should look into this further....

[June7]

Listbox or combobox is your preference. The point is that the popup might not be necessary.

I seldom use listboxes for data selection, usually a combobox. I have used listboxes a lot to just list data for viewing, instead of creating a subform.