"Missing" Records

[Guest]

I have an access database consisting of a number of linked tables. There is a
form based on two of the tables (one as a subform within the other) and also
a 'short' version of the form (created using the form wizard) which is a
single form but contains fields from >1 table. I also have a number of
queries based on >1 of the tables.

The main table contains ~250 records, which all show up in the full version
of the form. The short version, however, only 'sees' ~215 records. The
queries also seem to miss out some of the records (the same records that are
missing from the form).

Has anyone come across this before, and did you find out why some records
seem to 'disappear'? I can only think it is something to do with the queries
and form being based on >1 table, but I can't see anything wrong with the way
the database is set up.

Thanks,
Helen

 

[Allen Browne]

You need to use an outer join in your query, or possibly to adjust the way
you are using criteria.

Details of these 2 issues in:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html

 

[Arvin Meyer [MVP]]

Open the offending form in design view, turn on the property sheet, and
click on the Data tab. If you see a filter there, that could be the culprit.
Clear the filter and save the form. Then open the form in form view and
check your record count.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access