access

  • Thread starter Thread starter rocker
  • Start date Start date
R

rocker

I am having problems with my invoice report. the report is based on a
selected query and when i add a new customer to the tables that is in the
query, it does'nt get update in the query. so when i go to print out the
invoice report i can't find the new entry i put in the the table. Please help
me
 
Hi,
can post the names of your tables, their primary keys and foreign keys and
the relationsips between the tables. Without some knowledge of your database
it's very hard for us to make any suggestions.

Jeanette Cunningham
 
Queries do not hold any data. They only manipulate or retrieve data in
tables. If your customer is not showing up in the query, it is because the
new customer record is not yet in the table. Be sure you are saving the
record to the table before running the report. In the code for the button
that runs the report, add this at the begining of the procedure:

If Me.Dirty Then
Me.Dirty = False
End If
 
Queries do not hold any data. They only manipulate or retrieve data in
tables. If your customer is not showing up in the query, it is because the
new customer record is not yet in the table. Be sure you are saving the
record to the table before running the report. In the code for the button
that runs the report, add this at the begining of the procedure:

If Me.Dirty Then
Me.Dirty = False
End If
Click to expand...

Another common error is that your query uses inner joins (the lines
connecting the tables don't have arrowheads). In this case, your
customer might be in the table, but if there's no matching record in
the other table, they will not appear in the query.

One solution is to change your join properties so that all Customers
are displayed (the arrow will point away from the Customer table.)

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top