View Single Post
  #2  
Old October 23rd, 2009, 08:47 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Default text box as query filter

I'm pretty sure that a DefaultValue will work. I know an assigned value will
work.

In the criteria box, right-click and choose "Build" The navigate to the
textbox on your form.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Claire" wrote in message
...
I have unbound text boxes on a form header that have default values. The
query on which this form is based is filtered according to these values.
Right now, when I open the form it asks for these values as parameters.

Is there a way to automate access to use the default value for a text box
as
the parameters or to open/load the header before the rest of the form so
that
the defaults are already loaded? Would it be better to assign these
values
as an on load event instead of as defaults?

Thank you for any suggestions you have!

~Claire