Hidden Records???

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Is it possible to have records hidden in a table so when
you do a query on that table no records are returned?

Here's my delima. In a database that was built by another
user, I am trying to retreve some records that were
entered about a month and a half ago. When I go to the
form and select the proper Test number (we use a Test
Numner as a ID), each sample is displayed on a form. But,
when you try to look this up in a table or query the table
for the information, the test number acts like it has been
hidden or deleted.

Anyone have something similar happen?
 
Eric said:
Is it possible to have records hidden in a table so when
you do a query on that table no records are returned?

Here's my delima. In a database that was built by another
user, I am trying to retreve some records that were
entered about a month and a half ago. When I go to the
form and select the proper Test number (we use a Test
Numner as a ID), each sample is displayed on a form. But,
when you try to look this up in a table or query the table
for the information, the test number acts like it has been
hidden or deleted.

Anyone have something similar happen?
Click to expand...

No, can't say as I have. The first thing I'd check is the form's
RecordSource property, to make sure the records it's displaying actually
do come from the same table you're looking in. If the form's
RecordSource is a table, not a query, and you're looking in that same
table for a record that shows up on the form, then something very odd is
happening. But if the form's recordsource is a query, or you're using a
query to look things up in, then it could be that some records shown on
the form are produced by joining tables, or that some records are
excluded from the query by criteria or a table join.
 
Back
Top