An easy one I think

S

Sandy

Hi
I am creating some forms on the fly and I have 10 of them
set up already. I am having a silly problem when trying
to refer to each individual form because I need to set the
form via code.

Ie
strFormName = "ARPage" & z
docmd.OpenForm strFormName
Set frm = Forms!strFormName

The last line doesn't work because it is looking for a
form called strFormName instead of ARPage1.

Can someone please tell me how to set the form.

Thanks in advance
Sandy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top