checkbox and subform

  • Thread starter Thread starter KIT LAU
  • Start date Start date
K

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.
 
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.
Click to expand...

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.
 
Back
Top