I have a form with several check boxes, I use @XResultSetSearch to find a particular checkbox record. So, the field_spec_list would look like this “!Checkbox=” + vFirstbox. That works fine by setting vFirstbox to 1 and running @XResultSetSearch. Since I have several checkboxes, is there a way to change the “!field=” depending on the checkbox I want to search for rather than having to list each checkbox field? In other words, a variable for the "!field="?

Example, I would use @Popupmenu (only because it fits nicer for this application) to list the checkboxes, then when Secondbox is selected the “!field=” would be changed to this “!SecondCheckbox=” ,or assuming that it would be a variable, “!Checkbox=” would remain the same but receive the Secondbox variable.

Something like this.

vRS =  @XResultSetSearch(@FN, "Contacts, 0,2,  "!FieldVariable=" + vCheckbox)

If Choice = "01"
{
Set  "!FieldVariable="  to Checkbox 1
vCheckbox = 1
}

If Choice = "02"
{
Set "!FieldVariable="  to Checkbox 2
vCheckbox = 1
}
 

Outstanding!

Thank you Ray!