Subform Issue

[Guest]

I have a form that has a start date & an end date. I then run a query based
upon those dates. The form then has a subform which displays the results of
that query. However, there is no direct Child/Master relationship.

My problem is that when I go from design view to view form, the subform
disappears and a big white void shows up. If I open the subform by itself,
it opens just fne.

Any suggestions?

Thanks.

 

[Bob Howard]

Of course, you cannot open the form with the subform already open. close
the subform first.

Check the subform control in the main form --- specifically the "format"
attributes. Make sure Visible=Yes, and that DisplayWhen=Always.

Also check the format attributes on the subform's Form --- ViewsAllowed=Form
should be specified.

Also check the format attributes on the subform's "Detail" ---
Visible=Yes --- etc.

Bob.

 

[Guest]

I have the same problem. I have the mainform with subform. My mainform is
bounded to a recordsource, all the fields are unbounded. My subform is
bounded also to a recordsource and all the fields are bouded to the table.

The form and subform is working fine when I want to retrieve record using
the docmd.applyfilter strSQL (This the SQL constructed to retrieved record
into recordset). It displayed the record corresponding to the primary key
fields in the main form. Since the subform is bounded to the fields, if the
user entered record in the subform fields, of course the data is
automatically saved, since the subform is designed to continous form.

Is there any way to let the subform be unbounded too? so if the user is
playing with all the fields, no underlying data can be written. I want to
control and save both information using recordset object. I tried to unbound
the subform but it did not give me the data entry as a continous form. Only
one row and stack up there.

This things gave me a lot of code trying to validates each entry in the
subform to make sure that before the user exit, he has to save all the
information from the main form as all he entered in subform are already saved
by default without his knowledge.

I want to be the user completely flexible in data entry. If he entered data,
and leaves the form, no problem, no data has been written/updated to the
table until he chooses to save it. I can do this to the single form. But
subform is very complicated.

Please help... Thank you for your time...

jrb