can't view the subforms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aceavl - 04 Jul 2007 16:37 GMT

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.

Reply to this Message

Rob Parker - 05 Jul 2007 14:04 GMT

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

> hi, hope somebody can tell me what i did wrong! :(
>
[quoted text clipped - 10 lines]
>
> thanx.

Reply to this Message

aceavl - 05 Jul 2007 17:53 GMT

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?

Reply to this Message

Rob Parker - 05 Jul 2007 23:56 GMT

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

> 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
[quoted text clipped - 4 lines]
> i
> do?

Reply to this Message

aceavl - 06 Jul 2007 15:10 GMT

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!

Reply to this Message