Form using multiple tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cabfl - 21 May 2008 18:22 GMT

I have a form with three tables. In design view everything looks okay, but
the form is blank once you leave design view. Nothing but the title. How do
I see the form outside of design view in order to enter data?

Reply to this Message

Douglas J. Steele - 21 May 2008 18:27 GMT

Presumably your form is based on a query that joins the three tables.

Does the query return any data? If it does, is the resultant recordset
updatable? (It's very common for queries joining three or more tables not to
be updatable)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have a form with three tables. In design view everything looks okay, but
> the form is blank once you leave design view. Nothing but the title. How
> do
> I see the form outside of design view in order to enter data?

Reply to this Message

Cabfl - 21 May 2008 18:41 GMT

I entered test data and received data from the query but it is not updatable.

> Presumably your form is based on a query that joins the three tables.
>
[quoted text clipped - 6 lines]
> > do
> > I see the form outside of design view in order to enter data?

Reply to this Message

Douglas J. Steele - 21 May 2008 18:59 GMT

You didn't happen to set the form's DataEntry property to True, did you? If
so, set it back to False. The Data Entry property doesn't determine whether
records can be added; it only determines whether existing records are
displayed. If the underlying query isn't updatable and you've got DataEntry
set to True, then nothing will appear, since there's no "new record" row to
display.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I entered test data and received data from the query but it is not
>updatable.
[quoted text clipped - 12 lines]
>> > do
>> > I see the form outside of design view in order to enter data?

Reply to this Message

Cabfl - 21 May 2008 19:54 GMT

Thanks: I changed the Data Entry property to "No" and I can see the form.
How do I make it updatable?

> You didn't happen to set the form's DataEntry property to True, did you? If
> so, set it back to False. The Data Entry property doesn't determine whether
[quoted text clipped - 19 lines]
> >> > do
> >> > I see the form outside of design view in order to enter data?

Reply to this Message

Douglas J. Steele - 21 May 2008 20:38 GMT

If the underlying query isn't updatable, you can't.

Check what Allen Browne has at http://www.allenbrowne.com/ser-61.html for
some things you can check to see why the query isn't updatable.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Thanks: I changed the Data Entry property to "No" and I can see the form.
> How do I make it updatable?
[quoted text clipped - 29 lines]
>> >> > do
>> >> > I see the form outside of design view in order to enter data?

Reply to this Message