Opening forms from a list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brett - 07 May 2007 05:45 GMT

I have a subform that allows me to open selected reports. I want to create
the same thing but for opening and forms to allow for additonal data. I used
the same macro expression: =[Forms]![Maintenance]![lstMaintenance], however
it doesnt open the forms and just returns errors. Do i need a different
statement to open forms from that of reports?

Reply to this Message

Maurice - 07 May 2007 08:31 GMT

Well that depends on what your statement is. Remember that a form is opened
with docmd.openform and a report is opened with docmd.openreport. That could
be a minor difference...

Maurice

> I have a subform that allows me to open selected reports. I want to create
> the same thing but for opening and forms to allow for additonal data. I used
> the same macro expression: =[Forms]![Maintenance]![lstMaintenance], however
> it doesnt open the forms and just returns errors. Do i need a different
> statement to open forms from that of reports?

Reply to this Message