Turn off "select all" in datasheet field dropdown

[wineguy via AccessMonster.com]

Hi, novice here, Access 2007

Is there a way to turn off the checked "select all" for a field in a
datasheet? I have labor data by a dateperiod (for any given week) and rather
than the datasheet displaying all entries for all weeks I would like the user
to be able to use the dateperiod drop down in the datasheet to select which
week to see. Basically to have the datasheet blank until the user selects the
dateperiod. Is that possible?

Thanks in advance,

Glynn

 

[-Steve]

well, make the datasheet form a subform on another unbound blank form. 2)
put an unbound date period dropdown on the unbound form. 3) Use the after
update event of the unbound dropdown to change either the Recordsource or
the Filter and FilterOn properties of the subform.

Changing the value in the datasheet window will either overwrite the record
you are on or try to add a new one.

-Steve