Default form layout when creating new form

[MDB]

Hi,

In the Northwind sample database there is a table called Customers. When I have the table hilighted in the navigation pane and selected CREATE then FORM I expect to create a new form with only customer details. But rather the form displayed contains a split form including order details.

Where is this form coming from? Does access somehow look at the last form created that has this table as a data source? Is this an option that can be turned off? I'm assuming it's possible to have several forms for the same table as a data source?

Many thanks.
MDB

[rpeare]

If you look at the relationships of the database it goes from

Customer > Orders > OrderDetails

I suspect that when you click on FORM it's building a default form based on those relationships. Try getting rid of the relationships from CUSTOMERS to any other tables then recreating it and see if it creates a form by itself.

The other option is not to click the FORM button but to click the FORM DESIGN button and set up your own form without using the wizard.