Object Required Error

[TimTDP]

I need to requery numerous fields on a subform of a subform!
I use this:
[Forms]![frmCustomer]![frmCustomerQuotationManufactureDispatch]![frmCustomerQuotation].Form!lstQuotationDates.Requery

Because this is longwinded, I was hoping to declare the forms like this:
Dim ctlName

ctlName = "[Forms]![frmCustomer]![frmCustomerQuotationManufactureDispatch]![frmCustomerQuotation].Form"

and requery the fields using:
ctlName!lstQuotationDates.Requery

Access doesn't like this! I get an object required error.

What am I doing wrong?

Thanks

 

[Galaxiom]

Dim MyForm as Form
Set MyForm = [Forms]![frmCustomer]![frmCustomerQuotationManufactureDispatch].Form![frmCustomerQuotation].Form