Sql??

[George Too]

Can anyone tell me what these lines do:

Me.subfrmQuery.LinkChildFields = "Complaint_Information;Customer;Location"
Me.subfrmQuery.LinkMasterFields = "Complaint_Information;Customer;Location"

or do you need the whole code?

Thanks,

George

 

[Mile-O]

They are linking fields in your subform and main form.

 

[George Too]

Thanks Mile-O-Phile,
Now, why do I need to link these fields? See, I am working on a form where different combo boxes filter down the records but the last combo box won't work. I dowloaded the form and code from Candace Tripp's MS Access Downloads, what I noticed is that his/hers application has the same problem I am experiencing.

I suspect those two lines but I'm not that good with SQL. Any Ideas?

Regards,
George