Hi Fred! Thanks for the try and I'm sorry I took so long to reply I have been
on the road for most of this time. I wasn't quite clear enough on what I'm
doing I think.
I have a Customers form that has 5 tabs. In order, the first tab is
Customers, then Contacts tab, Notes tab, Calls tab, and Machine/Service tab.
The Machine/Service tab has 2 subforms. The 1st for Machines the customer
ownes and the 2nd for Service performed on each machine. They are both linked
to the CustomerID.
The Record Source for the Machines subform is:
SELECT qrysubfrmMachine.MachineModel, qrysubfrmMachine.CoAddressID,
qrysubfrmMachine.MachineSerialNumber, qrysubfrmMachine.InstallDate,
qrysubfrmMachine.FirstName, qrysubfrmMachine.Notes
FROM qrysubfrmMachine;
This forms View is Continuous Forms

The Record Source for the Service subform is:
SELECT Service.ServiceID, Employees.FirstName, Service.ServiceType,
Service.DateOpened, Service.DateClosed, Service.CustomerID
FROM Employees INNER JOIN Service ON Employees.EmployeeID =
Service.EmployeeID;
This forms View is Datasheet

In the Machines subform I have all of the machines owned by the customer and
in the Service subform it shows ALL service done to ALL machines owned by the
customer. What I want is to have service done for one machine at a time
depending on the record selected in the Machines subform. I don't even care
if the Service subform shows anything before a record is selected in the
Machine subform.
I'm really stuck here!!! I hope someone can help
Thanks again!!!