Viewing only the current record

D

DDrowe

What is the trick to be able to go back and review past records in a
datavase? I have a DB which uses a form for the data entry and currently I
have it set so that the user can not easily go back to past entries. I would
like to modify it from time to time to be able to go back on my forms page
and print out ones that have already been entered or completed,

Thanks

David
 
J

John W. Vinson

What is the trick to be able to go back and review past records in a
datavase? I have a DB which uses a form for the data entry and currently I
have it set so that the user can not easily go back to past entries. I would
like to modify it from time to time to be able to go back on my forms page
and print out ones that have already been entered or completed,

Thanks

David
Click to expand...

The "Data Entry" property of the form is what's causing this. That's exactly
what a Data Entry form is designed to do - allow new records to be entered,
but conceal existing ones.

To see past records open the Form in design view and change the Data Entry
property to No. You can put code in the form's Load event to jump to the new
record when the form is opened, but still leave the older records visible; or
you can write code to toggle the data entry setting on and off if you prefer.


However, for *printing out* data, a Report is a much better tool. Forms are
designed for onscreen interaction, not for printing.
 
Top