Using a checkbox help

[gbjc105]

Hey. I have a form that has 133 different records in it all linked together by a PlaceID. You can cycle through them and all of their relevant sub-form information is displayed.



Some of these sites are potential Villages and some are not. I have a table linked to PlaceID called potential villages with a simple list of the place ID's that are potential villages, there are 35. Its a table with only one field, the relevant PlaceIDs.

Is it possible on my form to have a checkbox that will represent which of PlaceID's are in the table? So if it is in the table it is checked and if not, it is empty. Furthermore, i would like any new checked PlaceID's to be added to the VillageTable.

So my table structure is:

IndexTable VillageTable
PlaceID ------ PlaceID
PlaceName

[llkhoutx]

You don't need a checkbox to tell you that a field is empty. You can test whether or not the field is empty.