I have a form that is using combo box selections to create a query for a large table. I need to use two items from the 1st combo box to create the query, but can only figure out how to use one. "Name" is used to display a station name to the user, while "MaintSched "is used as an afterupdate for the next combo box. I use "Me.txtStation" (shown below) to include the correct "MaintSched" value in the next query. How could I save "StationID" as a variable for use in a later query? SELECT tblSystem.StationID, tblSystem.MaintSched, tblSystem.Name FROM tblSystem; Me.txtSubsystem.RowSource = _ " SELECT ID, SubSystem, MaintSchedule" & _ " FROM tblSubsystems" & _ " WHERE MaintSchedule = " & Me.txtStation & _ " ORDER BY SubSystem"