Form objects not showing form view...

[Guest]

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.

 

[John W. Vinson]

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]

 

[Guest]

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]

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?

 

[John W. Vinson]

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]