query from form

[Steve]

Hello i have query which runs from a field in a form! in the query i have
this criteria
[FORMS]![FORM11]![CONSULTANT] in the consultant field

which works fine! however i do i get the query top pick up ALL (in this case
) CONSULTANT using this method!

thanks in advance

 

[frank knuckles]

You can copy the query and get rid of the criteria or you can build both
queries on the fly in VBA, adding the criteria when needed.

Or, you might want to look at:
http://www.mvps.org/access/queries/qry0001.htm which will give you all
consultants when the consultant field is empty. By using this method, you
can let your criteria point to an invisible field on your form. Before
running the query you give that invisible field either the value of the
consultant field (giving you only the current consultant) or make it null
(giving you all consultants).

FK

 

[Steve]

Brilliant !!1 works great! --
Thanks Steve

You can copy the query and get rid of the criteria or you can build both
queries on the fly in VBA, adding the criteria when needed.

Or, you might want to look at:
http://www.mvps.org/access/queries/qry0001.htm which will give you all
consultants when the consultant field is empty. By using this method, you
can let your criteria point to an invisible field on your form. Before
running the query you give that invisible field either the value of the
consultant field (giving you only the current consultant) or make it null
(giving you all consultants).

FK

Hello i have query which runs from a field in a form! in the query i have
this criteria
[FORMS]![FORM11]![CONSULTANT] in the consultant field

which works fine! however i do i get the query top pick up ALL (in this
case
) CONSULTANT using this method!

thanks in advance