Hidden Records on Form

[Guest]

Hi,

I have a contacts database and when I began entering data through a form I
created the records all showed and everything seemed fine. I closed the
database and opened it back up later. When I opened the form I had been
using to enter the data most of the records a disappeared. So I checked the
tables and thankfully all the data was still there. So I compared the
records that were showing the ones that were not.

I should mention this is a contacts database and as such there are many
fields that for some customers are left blank. However the one field that is
causing me problems is one called "Additional Information." This field's
data type is set to memo and the only records that show on my form are ones
where information has been entered into the "additional information" field.
I can't figure out why the forms seem to require this. Any suggestions?

 

[Rick B]

Sounds like your form must be based on a query that only pulls records with
data inthe [AdditionalInformation] field.

Check the query upon which your report is based and see what it is pulling.