Form from list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brett - 07 May 2007 05:42 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

Ofer Cohen - 07 May 2007 08:11 GMT

Use code insted of a macro,

Docmd.OpenForm Forms![Maintenance]![lstMaintenance]

If the field that specify which form to open located in a sub form, then the
path to retrive the form name will be different

Forms![MainFormName]![SubFormControlName].Form![FieldName]

Check help on the OpenForm command line, you can see there examples on how
to open the form for data entry only, or add a filter to the form using the
WhereCondition.
There are many options for oppening the form, it's worth checking it

Signature

Good Luck
BS"D

> 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