Using Queries In Multiple Forms

[boblovesyousomuch]

Hello,

I currently use a stored query in a form which performs a function that I would like to use in other forms. Ath the moment I use:

SELECT .. FROM .. WHERE Agent = [Forms]![FrmAgent]![AgentList]

This works fine but I want to be able to call this query in other forms that use the same 'AgentList'. I thought I would be able to write:

Me![AgentList]

but this does not work.

Any ideas?

Thank you in advance

Carl

 

[MarkWright]

Morning Carl
thought about packing it in a modul and calling the modul in each form. (Function)

just a thought
have a nice day

Mark

 

[boblovesyousomuch]

Am I right in saying i should paste the SQL query code in a module and just call it each time?

Just to clarify.

Sounds good to me though.

 

[MarkWright]

HI,
yes this is one of the easiest ways

Kind regards
Mark