No fields listed on my form in form view

I have my database set up. I have four tables in it. I
created a form using the fields from the four tables.
The fields appear in the design view of the form but when
I go to the view form there are no fields listed just a
blank form. Now if I use just one table with the fields
from it to design form and view the form the fields are
there. What am I doing wrong?

The detail section of your form goes completely blank if both:
a) there are no records to display, and
b) no new records can be added.

Examples of causes of a):
- Your form's DataEntry property is Yes.
- The RecordSource of the form is a table or query that has no records.
- You opened the form with a WhereCondition or applied a filter that has no
matches.
- You are filtering on a calculated field, unbound control, or undeclared
parameter, and Access misunderstands the data type. Details:
http://members.iinet.net.au/~allenbrowne/ser-45.html

Example of causes of b):
- Your form's AllowAdditions property is Yes.
- The form is based on a read-only query, or a query where you can't add new
records either.
- The database is opened read-only, or is from a read-only drive/network
share.
- Access security permissions do not allow adding new records.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nick" wrote in message
...
I have my database set up. I have four tables in it. I
created a form using the fields from the four tables.
The fields appear in the design view of the form but when
I go to the view form there are no fields listed just a
blank form. Now if I use just one table with the fields
from it to design form and view the form the fields are
there. What am I doing wrong?

The detail section of your form goes completely blank if both:
a) there are no records to display, and
b) no new records can be added.

Examples of causes of a):
- Your form's DataEntry property is Yes.
- The RecordSource of the form is a table or query that has no records.
- You opened the form with a WhereCondition or applied a filter that has no
matches.
- You are filtering on a calculated field, unbound control, or undeclared
parameter, and Access misunderstands the data type. Details:
http://members.iinet.net.au/~allenbrowne/ser-45.html

Example of causes of b):
- Your form's AllowAdditions property is Yes.
- The form is based on a read-only query, or a query where you can't add new
records either.
- The database is opened read-only, or is from a read-only drive/network
share.
- Access security permissions do not allow adding new records.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nick" wrote in message
...
I have my database set up. I have four tables in it. I
created a form using the fields from the four tables.
The fields appear in the design view of the form but when
I go to the view form there are no fields listed just a
blank form. Now if I use just one table with the fields
from it to design form and view the form the fields are
there. What am I doing wrong?

Thanks for the help Allen I now have by fields listed on
my form. But I don't seem to be able to enter any data
into the form fields. I am using a query in my record
source for my form. How do I set things up to enter data?
-----Original Message-----
The detail section of your form goes completely blank if
both:
a) there are no records to display, and
b) no new records can be added.

Examples of causes of a):
- Your form's DataEntry property is Yes.
- The RecordSource of the form is a table or query that
has no records.
- You opened the form with a WhereCondition or applied a
filter that has no
matches.
- You are filtering on a calculated field, unbound
control, or undeclared
parameter, and Access misunderstands the data type.
Details:
http://members.iinet.net.au/~allenbrowne/ser-
45.html

Example of causes of b):
- Your form's AllowAdditions property is Yes.
- The form is based on a read-only query, or a query
where you can't add new
records either.
- The database is opened read-only, or is from a read-
only drive/network
share.
- Access security permissions do not allow adding new
records.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nick" wrote in
message
...
I have my database set up. I have four tables in it. I
created a form using the fields from the four tables.
The fields appear in the design view of the form but
when
I go to the view form there are no fields listed just a
blank form. Now if I use just one table with the
fields
from it to design form and view the form the fields are
there. What am I doing wrong?


.

Can you enter data into the query? If not, you won't be able to enter it in
the form either, so work on the query.

To start with, only include the fields from one table in your query. Use
subforms to enter related records into further tables. Use combo boxes to
get/display the values from lookup tables. (Once you become familiar with
that approach, you can sometimes get away with using multiple tables in the
source query.)

Also, don't perform any aggregation in the query.
For example, it will be read-only if it:
- is a Totals query (has GROUP BY clause),
- is a crosstab query (TRANSFORM clause),
- asks for Unique Value (DISTINCT predicate).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nick" wrote in message
...
Thanks for the help Allen I now have by fields listed on
my form. But I don't seem to be able to enter any data
into the form fields. I am using a query in my record
source for my form. How do I set things up to enter data?

-----Original Message-----
The detail section of your form goes completely blank if
both:
a) there are no records to display, and
b) no new records can be added.

Examples of causes of a):
- Your form's DataEntry property is Yes.
- The RecordSource of the form is a table or query that
has no records.
- You opened the form with a WhereCondition or applied a
filter that has no
matches.
- You are filtering on a calculated field, unbound
control, or undeclared
parameter, and Access misunderstands the data type.
Details:
http://members.iinet.net.au/~allenbrowne/ser-45.html

Example of causes of b):
- Your form's AllowAdditions property is Yes.
- The form is based on a read-only query, or a query
where you can't add new
records either.
- The database is opened read-only, or is from a read-
only drive/network
share.
- Access security permissions do not allow adding new
records.

"Nick" wrote in
message
...
I have my database set up. I have four tables in it. I
created a form using the fields from the four tables.
The fields appear in the design view of the form but
when
I go to the view form there are no fields listed just a
blank form. Now if I use just one table with the
fields
from it to design form and view the form the fields are
there. What am I doing wrong?