Form opens blank in add mode

[mkelly]

I have a form for a quote request, it is made up of 4 seperate tables conected within a query. Date from three of the tables stores in the quote table based on the Key for the record in the other tables. However I can see all my controld in the edit mode but when I open the form in the add mode it is a blank white form? Any suggestions?

 

[Mr. B]

Many times when you create a multi-table query, that query does not allow records to be added or updated. If you have a one-to-many relationship between your tables, you can be sure that you will not be able to update the data in all tables using your current query.

First, open and run your query. Then try modifying or adding records in the query view. This will tell you if you have a query that will or will not allow additions and/or updates to the data.

Working with one-to-many relationships between tables is what subforms are for.

HTH