Form objects not showing form view...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve P - 16 Apr 2007 03:42 GMT

Hi guys. I've built a couple forms and after a certain point in the design
process, some how none of the objects are showing up in the form view.

Why am I getting a blank form in the form view?? The objects are still
visable in the design view.

Reply to this Message

John W. Vinson - 16 Apr 2007 06:47 GMT

>Why am I getting a blank form in the form view?? The objects are still
>visable in the design view.

This suggests that there's a problem with the Form's Recordsource query: it
probably is not updateable (so you cannot see the blank "new" record, because
you can't add records) and doesn't return any records (so you can't see any
records with data either). In this case Access will just decide "hey, nobody
here, just shut down this show" and display a completely blank form.

Try opening the Form's Recordsource: dollars to donuts you'll just get a row
of header field labels and nothing else.

If that's the case, post the SQL of the query and describe what you're
intending it to do.

John W. Vinson [MVP]

Reply to this Message

Steve P - 17 Apr 2007 19:26 GMT

> >Why am I getting a blank form in the form view?? The objects are still
> >visable in the design view.
[quoted text clipped - 12 lines]
>
> John W. Vinson [MVP]

Thanks for your reply John.

I did notice that it appears to be an issue related to the table from which
the form is based. The table that I want my form to relate to has a junction
table associated with it. Does that matter in how the objects are set up?

Reply to this Message

John W. Vinson - 17 Apr 2007 21:28 GMT

>I did notice that it appears to be an issue related to the table from which
>the form is based. The table that I want my form to relate to has a junction
>table associated with it. Does that matter in how the objects are set up?

Yes, of course it matters.

Normally for a many to many relationship, you would use a Form based on one of
the "one" side tables, and a Subform based on the junction table. Commonly one
would have a combo box or other selection tool on the subform to select the
link to the other "one" side.

For an example see the Orders form in the Northwind sample database. The main
form is based on Orders; the subform on OrderDetails, which is a junction
table; on that subform is a combo to select Products, the other side of the
many to many.

John W. Vinson [MVP]

Reply to this Message