I am using an access backend and DAO for this program.

I am trying to do a search on a home phone number that will bring up four recordsets that go with this home phone. I know how to do a search on just one recordset, but have no idea how to do this with four recordsets.

Please help me!