Hi,

I am having a little trouble trying to figure this one out.
I have a series of independant checkboxes on a form called
[GlobalScriptRecords] that are bound to their
corresponding fields in the table [GlobalScriptRecords].  
They aren't part of an Option Group because more than 1
box can be checked per record.

There are a total of 30 checkboxes:

DPP, GOPT, NMKT, SBA, etc.

What I would like to do is have these checkboxes return a
temporary (won't be stored) Text value = to their name
when they are checked, take those Text values and store
them in a temporary or static table and have a combo box
field on an unbound form that is bound to that temporary
table field, display unique values in the drop down, and
uses those values to search for records in the
GlobalScriptRecords table according to what text value was
chosen in that combo box pull down, and display those
records on another form.  Is this possible?  Does this
make any sense?  Please help.
Thanks,

Ron

It would make a lot more sense, if you stored these fields as values in a
separate table.  In other word, instead of having 30 boolean fields, you
would have one field, that would store the VALUES: DPP, GOPT, NMKT, SBA,
etc.

This is basic database design.  You don't say what these things are, so I
will pretend they are Departments.  To design your table structure properly,
it would look something like this:

GlobalScriptRecords               Departments
==============               ============
GlobalScriptRecordsID--|       DepartmentID
<other fields>                  |--< GlobalScriptRecordsID
                                              Department

Therefore, all of your Departments are already in the format that you need
for a listbox.

--
Roger Carlson
www.rogersaccesslibrary.com