Missing records in Access 2000

T

Tinee

I use access for a database of association members. Occassionally a new
record is posted into the members table but cannot be viewed any way except
through the table. This includes forms, queries, reports. All new members are
entered through a Form which places information into 2 tables. I have
attempted to enter new members through the table directly & it is stored but
not searchable through any method. What can I do to a) make these records
visable to the search or b) change what I am doing to enable the records to
be searched?
The database used to work "normally" but I am not sure when the problem
started
As only a few records have been affected, I have deleted them & re-entered
with no problems through the Form. At this stage ther is only 1 record
affected, but I would like this to stop
Please help
 
A

Allen Browne

Are the "missing" records supposed to show up in a subform?
If so, chances are that they are saved with a Null foreign key.

This can happen even if you created a relationship between the 2 tables with
Referential Integrity checked. Typically what happens is that the user
enters a record in the subform when the main form is at a new record. Access
accepts the record, but it never shows up in the subform again, because it
does not match any record in the main form.

If that is the cause, the solution is to open the related table in design
view, and set the Required property of the foreign key field to Yes, so that
Access cannot save the record with the null foreign key.

If that does not describe your case, it is possible that you have a
corrupted index. If so, you should be able to solve the problem with a
repair, i.e.:
Tools | Database Utilities | Compact and Repair.
 
T

Tinee

Thanks for the quick responce Allen
No the records are just supposed to go to the tables and sit there unless I
use the same Form I entered them with to view them, or use the record in
queries, reports etc. I constructed a new form to see if was that but the
record will not display there either. I followed your advice & "compacted &
repaired" then closed the db & reopened. The record is still in the table but
not searchable.
 
A

Allen Browne

So this is not a subform.

What is the RecordSource of the form (on the Data tab of the Form
Properties, in form design view)? Is it a query? SQL statement? Table name?
 
Top