I have built an Access 2010 database with the data in a SQL Server (2008) called WH.  It will be used for a project that is phased in over time. There is a main form (frm_Check_Incidents) that pulls in data from another SQL server (Brown) with a list of incidents.  The users are going to phase in the usage of the db over time and will start by using one facility, and then adding a few more each week.  I want to create a form that allows them to select all the Facility_Name values to include from the table ORG_FACILITY in SQL db Brown they want to work with. This selection needs to be saved as it only changes once a week or so.  These values then need to be used as the parameter values for the other form.  Is this possible?  

Your question is very vague.

You really need to provide some tables, fields (names and data types), form record sources, etc.

I think you need to create a table in some database to store a value (ideally a primary key) so that it can be used for filtering or whatever.

Duane
Hook'D on Access
MS Access MVP