Query SQL

[iostream]

I have form and I want specify records source.

So, I have query, for example:

SELECT fields FROM table WHERE id = !!!

where "!!!" I want get dynamic value (id) from for example input (from form).
How can I do it in Access?

[pbaldy]

Try

SELECT fields FROM table WHERE id = Forms!FormName.ControlName