'Me!' syntax running a query from a form.

[postmanphat]

MERRY CHRISTMAS!

I want to be able to run one query from various different forms. So for the criteria in the query design grid I've tried various combinations of

[Me].[Forms].[AppID]
[Forms]![Me]![AppID]

and so on, but none work. All the forms in question have the AppID field.

Its been a while since I've really used Access and know this is possible but I'll be damned if I can remember it!

Many thanks in advance people!

 

[Ed2020]

For a query to reference a control on a form the syntax is:

Forms!FormName!ControlName

If you're running the same query from multiple forms that will be a little more complex.

Perhaps you could return the value in a public function and reference the function in your query instead:

Public Function RetVal(ByVal strFormName as string, ByVal strControlName as string)
    RetVal=Forms(strFormName).Controls(strControlName).Value
End Function

Ed Metcalfe.

Please do not feed the trolls.....

 

[Ed2020]

Alternatively you could use a parameter query and pass your value to the parameter in code before running the query...

Ed Metcalfe.

Please do not feed the trolls.....

 

[postmanphat]

Is there not a way though of using

Forms!Me!ControlName

to reference a control on whatever the active, open form is?

 

[Ed2020]

Not if you're using it in the query. At least not that I'm aware of.

I'm sure somebody's going to prove me wrong now...

Ed Metcalfe.

Please do not feed the trolls.....

 

[PWise]

try

select * 
from tablename
where fieldname=[screen].[ActiveForm]![controlname]

but you must run this from thr form

i.e.
on button click

docmd.openquery "queryname

 

[dhookom]

If the query is the record source for a form or report and the [AppID] field is in the record source, then I would remove the form/control reference from the query and use the where condition argument of the DoCmd.OpenReport method. This would make your query less dependent on a form or forms.

Duane MS Access MVP
Now help me support United Cerebral Palsy