Open a form by selecting from a list

[Guest]

I found a query/form for opening reports.
It is =[Forms]![View Reports]![lstReports]

I love it! It works wonderfully!
So, I thought I would use it to open a form instead of a report. I thought
all I would need to do is change the macro up a bit, but it isn't working.
Instead of using the above query, I am using: =[Forms]![View Capital
Projects]![lstReports]. It doesn't open the form 'View Capital Projects'.
What am I doing wrong?

 

[Guest]

Without being able to see all your code, we can't tell.
Post the code, the SQL of the query, and what the Macro is doing.

 

[Guest]

Klatuu,

It looks like it is driven from a macro. I copied it from one of the
Microsoft Templates online. It is called Inventory Management Database. I
imported it into my engineering database. It works perfectly, as long as i
use it to open reports. But when i tried changing it from listing forms
instead of reports, it decides to not work.
The ViewReports form has an unbound control that is called lstreports. The
unbound control called lstreports has a macro assigned to it. The Macro is
activated when you Dbl Click. The Macro is: =[Forms]![View
Reports]![lstReport].
Can I email you the example?

Without being able to see all your code, we can't tell.
Post the code, the SQL of the query, and what the Macro is doing.
--
Dave Hargis, Microsoft Access MVP

I found a query/form for opening reports.
It is =[Forms]![View Reports]![lstReports]

I love it! It works wonderfully!
So, I thought I would use it to open a form instead of a report. I thought
all I would need to do is change the macro up a bit, but it isn't working.
Instead of using the above query, I am using: =[Forms]![View Capital
Projects]![lstReports]. It doesn't open the form 'View Capital Projects'.
What am I doing wrong?

 

[Guest]

Sorry, Angela, I don't publish my E-mail address.
--
Dave Hargis, Microsoft Access MVP

Klatuu,

It looks like it is driven from a macro. I copied it from one of the
Microsoft Templates online. It is called Inventory Management Database. I
imported it into my engineering database. It works perfectly, as long as i
use it to open reports. But when i tried changing it from listing forms
instead of reports, it decides to not work.
The ViewReports form has an unbound control that is called lstreports. The
unbound control called lstreports has a macro assigned to it. The Macro is
activated when you Dbl Click. The Macro is: =[Forms]![View
Reports]![lstReport].
Can I email you the example?

Without being able to see all your code, we can't tell.
Post the code, the SQL of the query, and what the Macro is doing.
--
Dave Hargis, Microsoft Access MVP

I found a query/form for opening reports.
It is =[Forms]![View Reports]![lstReports]

I love it! It works wonderfully!
So, I thought I would use it to open a form instead of a report. I thought
all I would need to do is change the macro up a bit, but it isn't working.
Instead of using the above query, I am using: =[Forms]![View Capital
Projects]![lstReports]. It doesn't open the form 'View Capital Projects'.
What am I doing wrong?