Access qry run from within a table

[martyuk1975]

Morning all, I have a linked Qry on access that looks up other data depending on what you select in other primary fields but the Qry only displays and runs for the first entry and does not refresh per entry line.

Does anyone know how to make a Qry refresh on each no database entry line/input?



Many thanks for you help in advance.

Martin.

[Minty]

What is the query?
In the query window right click and select SQL View. Copy and paste that here.
Enclose it with the code tags by highlighting it and clicking the # key in the thread reply editor.

[martyuk1975]

SELECT DISTINCT EQU_LIST.[Process Code]
FROM EQU_LIST INNER JOIN MAIN_DATABASE ON EQU_LIST.[Process Level] = MAIN_DATABASE.[Process Level]
WHERE ((([MAIN_DATABASE]![Process Level])=[EQU_LIST]![Process Level]));

This is the QRY that is linked to the process code on the MAIN DATABASE..

I want it just to allow a selection from a dropdown in the table when a certain process level is selected.

[Minty]

Remove the criteria (the WHERE Clause)- as you already have that in the join properties.

If that doesn't work, remove the DISTINCT , although I'm sure that isn't your problem.

[orange]

martyuk

This objective doesn't seem to match your thread title

I want it just to allow a selection from a dropdown in the table when a certain process level is selected.

What exactly are you trying to do in simple English?
You may want to research Forms and Controls.