access

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
--
Rocker-HarlemsBoy

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

"rocker" wrote in message
...
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
--
Rocker-HarlemsBoy

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 procedu

If Me.Dirty Then
Me.Dirty = False
End If
--
Dave Hargis, Microsoft Access MVP


"rocker" wrote:

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
--
Rocker-HarlemsBoy

On Thu, 27 Dec 2007 09:23:01 -0800, Klatuu
wrote:

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 procedu

If Me.Dirty Then
Me.Dirty = False
End If

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