Blank forms

[Guest]

I've had this problem before, but I'm not sure how it happened again. I can
enter data into my form and subform, it stores the data in the correct table,
but when I change focus the data is no longer viewable in the form or
subform.

How do I fix it so the data is always viewable in the form?
and
How do I prevent this from happening again?

Thanks.

 

[Jeff Boyce]

If the form's Data Entery property is set to Yes (or if the form is opened
in DataAdd mode), you won't see records already in the table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

So I set the Data Entry to No on the main form and the subform. I don't ever
remember changing it from when it worked. The only thing that's happened is
the db sat unused for a month. ???

 

[John W. Vinson]

I've had this problem before, but I'm not sure how it happened again. I can
enter data into my form and subform, it stores the data in the correct table,
but when I change focus the data is no longer viewable in the form or
subform.

How do I fix it so the data is always viewable in the form?
and
How do I prevent this from happening again?

Thanks.

Just turn off the form's DataEntry property, and remove any filters that might
be hiding records.

John W. Vinson [MVP]