Filtering problem

[Lori]

I have two tables that are linked together for a report. One is my
tblLegalLog and the second is the tblLegalLogDetails. The first table
provides project numbers, responsibility and location. The second provides
invoicing details for legal invoices. I can very easily run a report that
will give me every project, status and invoice. I also have a filter form to
filter the data based on project number, status, location or responsibility
(all data from the table not a query thru an SQL statement).

Here is my problem.

Two of my entries show up perfectly on the base report (all data) but when I
attempt to filter the data by any of the four available categories, the
fields are blank.

I have an autonumber set up for the LogID that links the two tables, I've
verified that the IDs match and there are no duplicates so I can't figure out
why this is happening. The tblLegalLog only has 129 entries, while the detail
section has less than 1000.

This happened on a different pair of tables in the database and I was able
to fix the problem by recreating the tables (a real pain) and setting a new
ID number. I tried that yesterday with these tables and the only thing it did
was switch the project that it wasn't showing (it went from 1440000 to
1204600).

HELP!!! I'm stumped.

 

[KARL DEWEY]

all data from the table not a query thru an SQL statement
Why are you not using a query?
Is this because you are only applying criteria to one of the categories and
not the others?