can't view the subforms

[aceavl]

hi, hope somebody can tell me what i did wrong!

i have a form with 4 pages and each 1 has 3 subforms that get their data
from diferent querys, it was working fine but suddenly it doesn't show
anything not even the tabs at the top to change pages!

in disign view it looks fine (
http://advenet.com/photos/aceavl/picture611.aspx) but when i open it it shows
nothing (http://advenet.com/photos/aceavl/picture612.aspx).

what happend?

thanx.

 

[Rob Parker]

What you are describing seems like what you get when the record source for
your form returns no records. In that situation, nothing will appear in the
detail section of the form.

Try opening the query (most likely, but it may be a table) that is the
form's record source, to check that it is returning some records.

HTH,

Rob

 

[aceavl via AccessMonster.com]

Hi Rob thanx for answering! yes 2 of the querys aren't returning results
they only do if you have something scheduled for that day, but the other 2
are returning several records, my problem is that i can't see the tabs so
that i can change to the pages that does have somthing, i've tried changing
the ones that have to the front (#1 page) and still can't see it! what can i
do?

 

[Rob Parker]

The problem will not be with the queries for the subforms (although if the
return no records, the subforms themselves will be empty (unless they are
set to Allow Additions). It will be the recordsource for the main form
returning no records, and the main form also being set to Allow Additions =
No.

HTH,

Rob

 

[aceavl via AccessMonster.com]

Finally! thanxs Rob!
you were right, the main form had the same recordsource as 1 of the subforms
that was getting no records, changed it to nothing and presto!