form contents show up in design view, but not in layout view

[magdiL]

Dear users!!



I have a problem with an existing database (which is an official database and has already been working). while in the design view I can see everything (form header, details, form footer), in the layout view the details disappear and I can only see form header and form footer. the form is used to load up data from an excel sheet.

do you have any idea what could be the problem? first I thought that maybe I have to put in some records, but this was not the problem. maybe there's some problem with the filters? I have never used access before and this is why I am quite confused...


thank you so much for your help,
all the best
magdiL

[pbaldy]

Typically, the record source of the form returns no records and doesn't allow new records.

[magdiL]

sorry, I don't understand your answer, can you specify it? thanks!!

[trevor40]

Check the display when option of the form detail section, options are allways, print only or screen only

[JeroenMioch]

Im not sure people are getting what you mean MagDil.
You might wanna show us a screenshot or something

[Missinglinq]

To expand on Paul's answer, Controls don't appear in Form View when three conditions exist at the same time:

• The Form is Bound to a Table or Query
• There are No Records in the underlying Recordset or the Recordset cannot be accessed
• The Form cannot have New Records added

The reasons that a Bound Form cannot have New Records added include:

1. The File's Read-Only Property has been set to Yes (has been ticked)
2. AllowAdditions for the Form is set to No
3. The underlying Query the Form is based on is Read Only
4. User doesn't have Read and/or Write Permission for the Folder where the Data resides or there is a connection problem with the network.
5. Folder the File resides in (in versions 2007/2010) not having been declared as 'Trusted'
6. Form's Recordset Type is set to Snapshot

Linq ;0)>

[June7]

Is the form RecordSource a query with 1 or more tables/queries/Excel link? Post the SQL statement.

This form used to work? What changed?