Checkboxes ?

[Trojnfn]

I have a form where I track notes from meetings. I need to track the attendace and the cities that are represented at the meeting. I was thinking of having checkboxes for the attendance names and cities and then just check them off.

Would this be the proper way to proceed ? If yes, how would I do it and how does the information get written into the table. I have a column called attendance and another call city, how would multiple values get inserted ?

Thanks for any help.

[goodguy]

Open the table in Design View.
Select the Attendance Column.
Click on the Lookup tab of the Field Properties Pane at the bottom.
Change the Display Control to Combo Box.
Change the Row Source Type to Table/Query.
Set the Row Source property.
Set the Bound Column Property.
Set the Column Count Property.
Set the Column Widths Property.
Set the Allow Multiple Values Property to Yes.
Repeat for Cities column.

[Trojnfn]

Open the table in Design View.
Select the Attendance Column.
Click on the Lookup tab of the Field Properties Pane at the bottom.
Change the Display Control to Combo Box.
Change the Row Source Type to Table/Query.
Set the Row Source property.
Set the Bound Column Property.
Set the Column Count Property.
Set the Column Widths Property.
Set the Allow Multiple Values Property to Yes.
Repeat for Cities column.

Thanks for your help. It seems to work but with a slight problem. Instead of giving me names, it just displays the checkbox with numbers, when I review the table in datasheet view.

I set the row source to the name of the master table that contains all the names and the bound column to 1, the column count is 1 and the column width is black. Are these settings correct ? All the others one are ok, but not sure about these.

[goodguy]

Thanks for your help. It seems to work but with a slight problem. Instead of giving me names, it just displays the checkbox with numbers, when I review the table in datasheet view.

I set the row source to the name of the master table that contains all the names and the bound column to 1, the column count is 1 and the column width is black. Are these settings correct ? All the others one are ok, but not sure about these.

Open the table in Design View.
Select the Attendance Column.
Click on the Lookup tab of the Field Properties Pane at the bottom.
Change the Display Control to Combo Box.
Change the Row Source Type to Table/Query.
Set the Row Source property:
To something like: SELECT NAMEID, FIRSTNAME FROM NAMES
Set the Bound Column Property.
If you are saving the foreign key to the Attendance field, the bound column from the above query is 1.
Set the Column Count Property.
There are two columns in our T=Row Source SQL, so set it to 2.
Set the Column Widths Property.
Set the Allow Multiple Values Property to Yes.
Repeat for Cities column.