Datasheet view subform

[Paul]

How to create a subform in datasheet view which is showing all the records
from a field in a table and four unbound fields as a checkbox format? What I
try to achieve is to show the product in one column in database view in a
subform along with four choices so that end user can select a choice(s) for
a product and eventually update this information for a selected product to
another table.

 

[Larry Linson]

First, unbound Controls don't work well on continuous view Forms; I don't
think you can add Controls to lines in datasheet view. So, you need to take
some other approach... and, if you expect the data to stay around long
enough for you to take action on it, you're going to have to store it
somewhere related to the record.

Easiest thing... create four Yes/No fields in your record. Once you
"eventually update... to another table", clear those fields.

Larry Linson
Microsoft Access MVP