Form to Control Query and Macro

[ryguy7272]

I’m not sure if this is a Forms question, a Query question, or a Macros
question, but I know it uses all three Objects, and the process is controlled
by a Form, so I’ll post my question here under the ‘Forms’.

On this site:
http://office.microsoft.com/en-us/templates/CT101426031033.aspx?av=ZAC000

I downloaded a few sample DBs. I took a look at one (Asset Tracking
Database) and reviewed the nuts and bolts of the DB. There is a form called
‘View Reports’ that shows each report when each item in the ListBox is
double-clicked. I am trying to adapt this feature for use in my own DB. I
think I effectively modified most of the functions and techniques for my own
DB, but there is something that is different between the file that I
downloaded and my own file. I believe it has to do with the Macro, called
‘View Reports Macro’. In the Design View of the Macro, there is a column
called ‘Macro Name’. I can’t seem to reproduce this column and I can’t get
the ‘lstReports : On Dbl Click’ into my Macro. Can someone please tell me
how to do this?

Thanks in advance,
Ryan---

 

[ryguy7272]

I finally figured it out. In the Macros view, right-clicking on the bar
(blue bar at the top of the window, I think it's called a title bar) will
display a few choices, such as Macro Names and Conditions. If you click on
Macro Names, and enter this into the Macro Name area:
'lstReports : on dbl click'

Then towards the bottom, enter this:
Report Name: '=[Forms]![frmReports]![lstReports]'
[frmReports] is the name of the Form and [lstReports] is the name of the
ListBox on the Form. The Access Bible is great, and good old fashioned trial
end error helps too.

Regards,
Ryan---