Sub Forms

[Nylex]

I am working on a cleaning system
I have a Form that I use to Add or Change my Customers details
To this form I have added a Subform that is linked to the main form and as I
look up a customer the subform lists all the properties that this customer
owns that we clean
I have another form that lists all the workorders by date and price entered
against a property
I have tried to add a 2nd subform to my Customer form (which I have never
done before) and it is there – how do I make it list the workorders to the
1st subform which has a property name and on the left hand side it has the
black arrow to show which property is highlighted – I only want it to list
the property that is highlighted
At the moment it list no properties

 

[jl5000]

One way to do it is to create a texbox in the main form, the control source
should be =[Subform1].[Property_Id] and name the textbox property_id (or
whatever field name you have that links to the work orders),

Then link your 2nd subform with customer_id;property_id