No fields listed on my form in form view

[Nick]

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?

 

[Allen Browne]

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]

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?

 

[Allen Browne]

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