I would like to display certain columns from a table on a form.
One of my columns that I want to show is a Yes/No field so that my
users can pick their players for a fantasy football week.
If they could use the table directly, the datasheet view allows them a
check box to set yes and no for the player in that row. However, I
don't want them to access the table directly.
I can't find a contol that will let me use the datasheet view on the
form.
Please tell me how to use the datasheet view on a form or what control
to use. Ideally, I would just like to have a Select statement for the
form that shows that shows the results like the datasheet table view.
Thank you.