Blank Form View

Brahm

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?

hjozinovic

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?

Brahm

Quote:

Originally Posted by hjozinovic

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

hjozinovic

[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.

missinglinq

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)>

Brahm

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

hjozinovic

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.

Brahm

Thanks again...it worked. Although I might have liked to know what exactly it was...

Blank Form View

re: Blank Form View

re: Blank Form View

re: Blank Form View

re: Blank Form View

re: Blank Form View

re: Blank Form View

re: Blank Form View

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about