Command Button in Datasheet View

[Michael]

Hi Folks - I'd like to display a list of records in datasheet view. One of
the fields is a checkbox. I'd like users to select the records to print,
then click a command button that runs a report. I thought a form in
datasheet view with a command button in the form header would easily
accomplish this task. However, it looks like a form in datasheet view cannot
display a command button. Do you have any workarounds? Thanks.

Michael

 

[benyod79 via AccessMonster.com]

Change Datasheet to Continuous Forms. Put the field labels in the form header
above the field's textbox, put all textboxes at the top of the detail section,
make all textboxes the same height, change the height of the detail section
to the height of the textboxes. BAM, you're done! Gives the appearance of
datasheet, but allows use of form header/footer.

 

[Klatuu]

Make your datasheet form a subform and put your command buttons on the main
form.

 

[Michael]

Awesome .... Thanks.

Change Datasheet to Continuous Forms. Put the field labels in the form
header
above the field's textbox, put all textboxes at the top of the detail
section,
make all textboxes the same height, change the height of the detail
section
to the height of the textboxes. BAM, you're done! Gives the appearance of
datasheet, but allows use of form header/footer.