forms and queries don't like to get along...

  • Thread starter Thread starter msj120
  • Start date Start date
M

msj120

Here is the situation:

I am trying to create a form where the users can enter query parameter
into a textbox located on the form, and then run the query with
button, also on the form. It doesn't seems like it should b
difficult, but I haven't had any luck with the answer
 
msj,

You are correct that it is possible to do this type of thing. When
you say "run the query", I assume it is an action query? What type of
action query is it? What happens when you try to run it? Are you
getting an error message of some sort? Or is it just that the query
is returning the wrong data? What type of data is being entered into
the textbox on the form? Is the textbox bound or unbound? Is this
textbox being referenced in the criteria of your query? If so, what
syntax are you using? What macro or VBA procedure do you have on the
command button? Could you give some examples? Thank you.

- Steve Schapel, Microsoft Access MVP
 
Back
Top