How can I hide previously entered data

[jlan]

Hello all! I've been lurking for some time but now I have a question I
woudl like to ask myself. I have a form and subform which is designed
to enter time sheet data. The main form is for the eployee info and the
subform is the timesheet data which is in the spreadsheet format. I
would like to be able to hide or somehow not display past data in the
form. IE when I enter this weeks timesheet data I don't want to scroll
down the spreadsheet past all the previously entered data to enter this
weeks. Also, I don't want anyone else entering to see previous data and
possibly modify it. How can I hide it?

 

[Rick Brandt]

Hello all! I've been lurking for some time but now I have a question I
woudl like to ask myself. I have a form and subform which is designed
to enter time sheet data. The main form is for the eployee info and
the subform is the timesheet data which is in the spreadsheet format.
I would like to be able to hide or somehow not display past data in
the form. IE when I enter this weeks timesheet data I don't want to
scroll down the spreadsheet past all the previously entered data to
enter this weeks. Also, I don't want anyone else entering to see
previous data and possibly modify it. How can I hide it?

If you set the DataEntry property of the form used in the subform control to
Yes then it will not display existing records and will only allow entry of
new records.

 

[jlan]

If you set the DataEntry property of the form used in the subform control to
Yes then it will not display existing records and will only allow entry of
new records.

 

[jlan]

Perfect, Thanks!!

 

[Ron2006]

However, if you are going to want to see (and modify)THIS weeks data
but NOT last weeks, then add a date range as criteria on the query you
are using to show this weeks data. That way they can see and modify
this week's info but not last week's.

Ron