By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,953 Members | 1,668 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,953 IT Pros & Developers. It's quick & easy.

Form fields will not display in Form View

P: 17
I recently converted an Access database built in Access 2000 to the Access 2007 format. Upon doing so, I created a new form that used a table from the old database plus two new tables created in Access 2007 in a blank form design. The form displays in Design view, but does not display in either Layout view or Form view.
May 24 '10 #1

✓ answered by missinglinq

If a form is bound to a record source and

The record source is empty

and

New records cannot be added

no controls will show on the form or its tabbed pages.

The reasons that a bound form cannot have new records added include:

1) AllowAdditions for the form is set to No
2) The underlying query the form is based on is Read-Only
3) User doesn't have Write Permission for the folder where the data resides.
4) Form's Recordset Type is set to Snapshot

To see if #2 is the case, from the Objects Dialog box go to Queries and click
on the query that your form is based on to open it. Now try to enter a new
record directly into the query. If you're unable to do so, this is the cause
of your problem.

If your query is Read-Only, follow this link to Allen Browne’s article
explaining the reasons this happens.

http://allenbrowne.com/ser-61.html

Linq ;0)>

Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
If a form is bound to a record source and

The record source is empty

and

New records cannot be added

no controls will show on the form or its tabbed pages.

The reasons that a bound form cannot have new records added include:

1) AllowAdditions for the form is set to No
2) The underlying query the form is based on is Read-Only
3) User doesn't have Write Permission for the folder where the data resides.
4) Form's Recordset Type is set to Snapshot

To see if #2 is the case, from the Objects Dialog box go to Queries and click
on the query that your form is based on to open it. Now try to enter a new
record directly into the query. If you're unable to do so, this is the cause
of your problem.

If your query is Read-Only, follow this link to Allen Browne’s article
explaining the reasons this happens.

http://allenbrowne.com/ser-61.html

Linq ;0)>
May 24 '10 #2

NeoPa
Expert Mod 15k+
P: 31,769
I would offer an aside here. I've heard that best results are achieved when updating if each intermediate version is updated to first. IE. From 2000 to XP, then on to 2003 then 2007.

Otherwise Linq has already provided a good and full answer I believe :)
May 25 '10 #3

P: 17
Thanks to all, it's now working!
May 25 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.