checkbox and subform

[KIT LAU]

Hi,

I would like to create a form that has a combo box to show
staff name. When the staff name is selected, a subform
will show ALL records of a table. There's a checkbox next
to each record.

I can only display the records that were checked but not
all the records of the table.

Could anyone help?

Thanks.

 

[John Vinson]

Hi,

I would like to create a form that has a combo box to show
staff name. When the staff name is selected, a subform
will show ALL records of a table. There's a checkbox next
to each record.

I can only display the records that were checked but not
all the records of the table.

What is the Recordsource property of the subform? If it's a query, it
appears that the query is referencing the checkbox field... if so,
just remove the criterion on that field.