Sub forms with no data

G

Guest

Hello,
I have a 4 page form that contains many subforms. There are upwards of 200
organizations with data in their respective 4 pages, so the data changes for
each set....i.e. some of the subforms will be populated with data for one
organization, but these same subforms might not be populated with data for
the next.

What is happening, is when there is data in the subform, it appears in the
printed form, which is good. However, when there is no data, the subform
disappears and does not apear in the printed form, which is bad. I want the
subform to appear even when there is no data. The reason that this is
required is so that when a hard copy of the form is printed and sent to an
organization, they can see the empty fields and pen data into them.

Can anyone help?

Thanks
Connie
 
A

Allen Browne

See:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html

The article explains why it happens, and suggests workarounds for different
cases.

Ultimately, forms are not very good for printing. You probably need to
create a query that uses outer joins. Then create a report based on that
query. You can set up the report to look the way it should more easily.
 
G

Guest

Thanks Allen,
I will check it out
Connie

Allen Browne said:
See:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html

The article explains why it happens, and suggests workarounds for different
cases.

Ultimately, forms are not very good for printing. You probably need to
create a query that uses outer joins. Then create a report based on that
query. You can set up the report to look the way it should more easily.
 
G

Guest

I ready your article and while it was helpful to know the ins and outs, most
of the settings you suggest are already set, or don't work for my form. What
I really need is for my subform fields to appear with or without data.

Any further suggestions?

Connie
 
A

Allen Browne

So you understand why the form is blank?
But you still want to generate a record?
And you cannot avert the situation where new records are not allowed?

Then presumably the form is already read-only, and you would need to code a
UNION query to add a record with the same number of fields (all null.)

See help on UNION queries.
 

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