By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,544 Members | 2,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,544 IT Pros & Developers. It's quick & easy.

Query by Form

P: n/a
I have spent more time than I am willing to admit trying to figure
this out...

I'm trying to use a form to manage the criteria in a query. This one
query feeds to numerous other append queries as part of a monthly
maintenance process. The query that I'm updating basically needs to
be changed each month to reflect the current month. I'm not looking
for the query to show me the results, I just want to use a form to
enter the criteria rather than open the query and change the criteriat
manually. If I use a parameter query, it asks me for the information
as soon as every append query loads.

HELP!
Jan 25 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Is it as simple as putting [Forms]![YourForm]![FormFieldName] in the
criteria section of the query or am I missing something?
Jan 26 '08 #2

P: n/a
On Jan 26, 5:53*am, anthony <anthony.marr...@gmail.comwrote:
Is it as simple as putting [Forms]![YourForm]![FormFieldName] in the
criteria section of the query or am I missing something?
I did try [Forms]![YourForm]![FormFieldName]

but whenever I used the drop down on that form, selected my criteria -
Other queries that I was running using that criteria weren't working.
It seemed like it would just show me results where as I actually
wanted to hardcode that criteria in the appropriate query. Does that
make sense?

All I am doing is going into this query each month an changing the
current month from 12 to 01 or 02 or whatever. I want to get this
database over to a group in another state who have never used access
before and I am trying to simplify how they will update these month
codes w/out having to go into any tables, queries, etc.
Jan 27 '08 #3

P: n/a
Sorry, should really have been [Forms]![YourForm]![FormControlName]

I'm having difficulty understanding why this isn't working. If all the
relevant fields are formatted as the same date format, then asking the
query to look at a form for its criteria shouldn't present any
problems. You mention that other queries stop working. Is this because
they are looking at the same control and expecting a different value
to the one you are using for your main query? If so, create a new
control specially for this purpose
Jan 29 '08 #4

P: n/a
anthony wrote:
Sorry, should really have been [Forms]![YourForm]![FormControlName]

I'm having difficulty understanding why this isn't working. If all the
relevant fields are formatted as the same date format, then asking the
query to look at a form for its criteria shouldn't present any
problems. You mention that other queries stop working. Is this because
they are looking at the same control and expecting a different value
to the one you are using for your main query? If so, create a new
control specially for this purpose
Could it be possible that one or more of your forms has its own Filter
Property set? I would check into this if your queries work outside of
form, but don't work when run with code in your form.
Feb 2 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.