Missing Record - 325 in the table, 324 showing on the form???

[highland]

I have a database which has one main form linked to a table which has 325 records in it. The problem is when you open the form it says there are only 324 records
I have gone through the table comparing the records with the form records, I found what I thought was the 'missing' record. But when I did a find on the form I managed to retrieve the record.
Can anyone help as I'm a bit baffled.

Thanks
S

 

[Pat Hartman]

Does the form have a filter that is eliminating a single record? Did you run a count query on the table?

 

[highland]

Thanks for your reply.

I have had another look and have found the record which is not being displayed in the form, I have done a search for it on the form and cannot find it.
There doesn't appear to be any filters on the form to prevent this record from displaying.

 

[jonesda]

Did you design the form using a query? Go into the data tab of the form properties and check if there is a query here which has some criteria preventing the record being displayed??

If your query is between 2 tables maybe you need to do an outer join??

Or if 2 tables on the form make sure that the relationship between the tables is correct - i.e. outer join.

 

[highland]

I have managed to get it to display the record.
I didn't design the database myself but I am now the person who has to maintain it.
When data is inserted into the title field they should use the lookup provided, but someone had entered a value which was not available on the lookup.

I have since amended it and now the record is displayed.

Thanks for all your replies.

 

[Bat17]

if they did this through a combobox then goto its properties and set 'limit to list' to yes and they won't do it again

peter

 

[Pat Hartman]

You also need to go to the relationships window and define a relationship between the two tables. Check the enforce referential integrity box. If any "bad" data is left in the table, Access will refuse to let you check the RI box. You will need to fix the data first.