Where is the form I just created?

[Teaa]

First time user.........makes form based on a query involving 3 tables.....when I switch to the form view I see a blank page.........why? I want to enter data in three tables from one form.

 

[Beeps]

Hi Teaa,

Assuming that you set the form's record source to the query you are using, the query relationships have to linked using primary keys that are the same for each table for changes to affect the tables.

For example, you could have "SystemID" as you primary key in a table, and another table with fields "SystemID" and "System Name". You would need to left join the tables with "SystemID" for you to be able to update the tables from the query.

You might consider using subforms for each secondary table. You can look up subforms in Help and the various ways you can use them as you didn't specify exactly what you are trying to do. This might be the easiest way to go

Hope it works out