W
wstobbs
Guest
Hi guys, I think that I am being dumb but here goes.
I need the query associated with a Combo Box row-source to filter records based on another field on the form.
I can get this to work just fine if I explicitally include the form name in the query, ie SELECT Client.Client FROM Company INNER JOIN Client ON Company.Company = Client.Company WHERE (((Company.Company)=[forms]![allcalls]![company])); My form name is AllCalls.
However, I will be having many similar forms so do not want to reference the form by name. I am sure that the form can be referenced by me! or something like that but try as I might I cannot get it working.
Am I making sense? and does anyone have a solution?
Cheers
Wayne
I need the query associated with a Combo Box row-source to filter records based on another field on the form.
I can get this to work just fine if I explicitally include the form name in the query, ie SELECT Client.Client FROM Company INNER JOIN Client ON Company.Company = Client.Company WHERE (((Company.Company)=[forms]![allcalls]![company])); My form name is AllCalls.
However, I will be having many similar forms so do not want to reference the form by name. I am sure that the form can be referenced by me! or something like that but try as I might I cannot get it working.
Am I making sense? and does anyone have a solution?
Cheers
Wayne