I have created a form using the form wizard. The data is from a query which pulls data from 3 tables. I designed the form in isolation and then copied it into my project.
I want to use this form in a collection. I've already done this with one form success fully. Let's say the form name is ListSaleItems
In VBA when I type the following
Dim frm As Form
Set Set frm = New f
I then get a list of objects and in particular a list of forms inthe format forms_xxxxx where xxxxx is the form name. My form ListSalesItems does NOT appear in the list.All the other forms I have do.
HELP!!
I want to use this form in a collection. I've already done this with one form success fully. Let's say the form name is ListSaleItems
In VBA when I type the following
Dim frm As Form
Set Set frm = New f
I then get a list of objects and in particular a list of forms inthe format forms_xxxxx where xxxxx is the form name. My form ListSalesItems does NOT appear in the list.All the other forms I have do.
HELP!!