database record not showing

Question

I entered a database record, but I cannot see it now. The record number does not show that it is there. But if I try to reenter it, Access tells me that is duplicate information. Any idea how to get it to show?

Answer 1

As Scott has asked, where exactly are you looking.

Have you searched directly in the underlying table?

Often, when a record isn't showing in a form/report, you need to review the record source, and also ensure no filter has been set on the form itself.

If code is used, then you also need to check that VBA isn't implementing some type of filter.

Answer 2

How are you trying to look for it? Are you looking at the table directly or just in a form? If a form, can you see any previous records?

Answer 3

Glad to have helped.

Answer 4

Thanks to you and Scottgem. I created the entry in forms, but after reading your answers I looked in tables to see what was there. I immediately saw the problem. In the column by which I alphabetize, I had typed a four instead of one. Since this last injury was a number two, that made it out of order. Fixed it and now everything is fine!

Thanks for your help and for the speed of your answers.

Answer 5

See reply at Daniel's answer.