Re: Empy form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rick Brandt (rickbrandt2_at_hotmail.com)
Date: 03/22/05


Date: Tue, 22 Mar 2005 08:28:52 -0600

Juan Mack wrote:
> I trying to figure out what I did. I can open a form in design mode,
> I see all the fields, but when I run the form it is empty (just the
> background). HELP!

(common question)

The detail section of a form will appear completely blank if there are no
existing records to display and no ability to add new ones.

The former can be caused by an actual lack of records or due to query
criteria and/or filters being applied. The latter can be caused by form
properties (AllowAdditions and RecordSetType) and/or because the form is
bound to a query that is not editable (most common).

-- 
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com


Relevant Pages

  • Re: Adding a new field in MSAccess DB ( newbie )
    ... Open the table in design mode and add the new field ... select the first cell of the date field and paste. ... not allow conversion, ... I would write a make table query. ...
    (microsoft.public.vb.general.discussion)
  • Re: Slow Query from Morning to Afternoon
    ... SQL Server MVP ... > I sure hope this is a common question with a common ... We have noticed that a query they may ... > are no issues regarding traffic or hardware. ...
    (microsoft.public.sqlserver.server)
  • Re: Slower Query from Morning to Afternoon
    ... SQL Server MVP ... > I sure hope this is a common question with a common ... We have noticed that a query they may ... > are no issues regarding traffic or hardware. ...
    (microsoft.public.sqlserver.programming)
  • Re: Slower Query from Morning to Afternoon
    ... >SQL Server MVP ... >> I sure hope this is a common question with a common ... We have noticed that a query they may ... >> are no issues regarding traffic or hardware. ...
    (microsoft.public.sqlserver.programming)
  • Re: Query will not open in Design Mode - Invalid use of Null
    ... can open thequeryin Design Mode to edit - I can view in sql mode. ... I have 3 records in Copy of tblCoa and 4 ... The query runs fine, the query will toggle back and forth from design ...
    (microsoft.public.access.queries)