Re: No Form In Form View

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 02/22/04 

Date: Sat, 21 Feb 2004 19:16:56 -0700

On Sat, 21 Feb 2004 16:36:15 -0800, "Frustrated"
<anonymous@discussions.microsoft.com> wrote:

>I have a form that when viewed in Design View, everything
>is okay. If I try to view the form in Form View, all I
>get is the background color. This is the form with the
>least amount of controls in the database, so I know it
>can't be because there are too many of them in the form.

This usually is the fault of the Query upon which the form is based.
If the Query returns no records, you won't see any existing records;
and if it's not updateable (or if the AllowUpdates or AllowAdditions
properties of the form are true) you won't see the new record either -
you'll just see a blank slate.

Try opening the Form's Query in data*** mode. Do you see any data?
do you see the *> new record line? If not, check the query to see if
it has something that would keep it from updating (see "Updateable" in
the online help), or open the query in SQL view and post it here.

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Quantcast