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

Blank Form View

P: 4
I am very new to Ms Access 2007 and I have been trying to create a simple database for my office. My tables are all related but if I try creating a form by dragging fields to the design view, when I click "form view" its blank...
Can someone tell me what is happening and how to correct it?
Aug 12 '08 #1
Share this Question
Share on Google+
7 Replies


100+
P: 167
Hi Bram,

I'll assume you have record source of the form set to the table/query you want, so you're dragging the fields from field list.
Is the visible property of the fields set to Yes?
Are you dragging the fields on to a Detail section?
Aug 12 '08 #2

P: 4
Hi Bram,

I'll assume you have record source of the form set to the table/query you want, so you're dragging the fields from field list.
Is the visible property of the fields set to Yes?
Are you dragging the fields on to a Detail section?
Hi
Yes, the record source is set right and the visible property is set to Yes. And I am also dragging it to the Detail section.
The field was created with a look-up wizard (if that helps)
Thnx
Aug 12 '08 #3

100+
P: 167
[HTML]I would try to set record source of the form to nothing and save.
Close the entire database.
Open again, and set the recordsource to the original table.
Save, and exit.
Open and try dragging fields.[/HTML]

It worked for me when I had no fields in the field list after setting new recordsource.
Aug 12 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
This is the classic description of what happens when a form has no records in it's Record Source and for whatever reason (such as AllowAdditions being set to No or the underlying query being read-only) the form doesn't allow new records to be added. Are these conditions true?

Welcome to Bytes!

Linq ;0)>
Aug 13 '08 #5

P: 4
Thnx for the welcome, Linq

Unfortunately those conditions are not true in this case. are there any other possibilities?

And i've tried what hjozinovic suggested (thnx btw) but my form hasnt changed. it still doesnt display my fields
Aug 14 '08 #6

100+
P: 167
Maybe you could create compeletely new form based on the same table/query and than try to dragg fields on it.
Or use wizzard for creating forms. That way fields will automaticaly be on the form.
Aug 14 '08 #7

P: 4
Thanks again...it worked. Although I might have liked to know what exactly it was...
Sep 2 '08 #8

Post your reply

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