Blank Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nancy - 19 Oct 2005 15:59 GMT

I am running a query that links several tables.

When creating a form and linking that form to the query, I can view the form
structure in Design View and Datasheet View, but not in Form View . . . it's
blank. At times if I structure the form data in the "Page Header" and not the
Details section I can see data, other times, I cannot. If I change the source
to a table, I can view all "Details" information in Datasheet, Form, and
Design views.

This also happens if I create a subform. If my subform is linked to a query,
I don't see any format, only a blank window, as soon I link it directly to a
table, data appears.

Reply to this Message

Rick B - 19 Oct 2005 16:09 GMT

As outlined pretty often in here, this indicates several things...

1) Your query is not updateable.

2) There are no records in the query upon which your form is based.

3) Your form does not allow additions.

In short, if the form source does not find any records and if you can't add
any records, then the form will be blank. Either modify your query to
include some records, or turn the form's "allow additions" on so that the
user can add records through the form.

Do a search and read the many previous posts on the subject "blank form" for
more details.

Signature

Rick B

>I am running a query that links several tables.
>
[quoted text clipped - 14 lines]
> a
> table, data appears.

Reply to this Message