My Form accesses a Query to retrieve 3 fields from 2 tables :
SELECT tblA.X, tblB.Y, tblB.Z
FROM tblA LEFT JOIN tblB
ON tblA.X = tblB.X
There are lots of rows being retrieved.
My Form has X set up in a combi box.
I wish to select the downarrow for X to select any row,
and then for Y and Z to display the corresponding values.
Eg : if the 1st row displayed is X1 Y1 and Z1, and I scroll down to row 20,
I want to see X20 Y20 and Z20.
But at the moment, I get X20 Y1 and Z1.
I suspect I will need to build an On Change Event Procedure for X,
to force Y & Z to be displayed, but I do not know how.
Many thanks for any help !
SELECT tblA.X, tblB.Y, tblB.Z
FROM tblA LEFT JOIN tblB
ON tblA.X = tblB.X
There are lots of rows being retrieved.
My Form has X set up in a combi box.
I wish to select the downarrow for X to select any row,
and then for Y and Z to display the corresponding values.
Eg : if the 1st row displayed is X1 Y1 and Z1, and I scroll down to row 20,
I want to see X20 Y20 and Z20.
But at the moment, I get X20 Y1 and Z1.
I suspect I will need to build an On Change Event Procedure for X,
to force Y & Z to be displayed, but I do not know how.
Many thanks for any help !