(Can DoCmd.openform allow formname from stored string value?)
I am needing to vary the FormName part of the .openform based on a result looked up in another table. as I have 10 Different forms that will be specific to a certain kind of record.
My code something like this:
NewFrmName = Dlookup ~~~looks up the form name from table
'so NewFrmName will end up NewFrmName = Frm_RepairParts or something
DoCmd.OpenForm NewFrmName, acNormal, "", "", acAdd, acNormal
Error I get is "the action or method required a form name argument"
so it does not like my NewFrmName variable and need another way of doing this.
anyone know a way to do what I am wanting ??