Can't view data in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I'm a very new user, so apologies if this is very basic.
I've created some tables with my data, and then made a form (based on a
query) to input the data.

However, I cant view the existing records on the form or on the query, but
only through the tables. Can anyone explain why this might be or do you need
more information

Thanks
 
Hi there,

I'm a very new user, so apologies if this is very basic.
I've created some tables with my data, and then made a form (based on a
query) to input the data.

However, I cant view the existing records on the form or on the query, but
only through the tables. Can anyone explain why this might be or do you need
more information

Thanks
Click to expand...

It's probably a mistake to create One Grand Master Query joining all
your tables. If ANY table is empty, or has no matching values, the
Grand Master Query will also be empty.

Instead, base your Form on the "one" side table of the one-to-many
relationships; and use Subforms for the "many" tables.

John W. Vinson[MVP]
 
when you open the query by itself (not by opening the form), you don't see
any records, is that correct? can you post the SQL statement from your
query, so we can see it?
to do so, open the query in design view. from the menu bar, click View | SQL
View. in the SQL pane, highlight the entire contents and paste into your
post.
 
Back
Top