Form view and fields based on query

[Guest]

I've created all of my tables, fields and relationships for my database.

Now, I would like to create a form to enter the data. I created a query with
all of the fields I want to include in the form. This is going well! When I'm
in Design View form I can see the fields, however, when I go into Form View,
the fields do not appear.

I read two articles regarding this problem and it seems there is something
wrong with my query. I've only created one query for the fields I wanted to
include. I guess my query is in read-only so I can't view the fields in the
form until there is some data. However, I want to enter all of my data in the
form as opposed to the table so I need to see the fields in the form. Queries
really confuse me... :-s

Please help!!!!!!

 

[Guest]

Add at least one record to the table.

 

[Duane Hookom]

Normally, my form record source query contains only a single table. I use
subforms to display records from related tables.

If you use multiple tables in your record soruce query, they should be
joined on Primary and Foreign Key fields. You haven't told us anything about
your tables, fields, and relationships so it is difficult to provide much
more direction.