Form from list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top