Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filters for append query and resultant form

Status
Not open for further replies.

billheath

Technical User
Mar 17, 2000
299
US
I cant seem so find a way to incorporate a single filter for an append query and then open up just the appended records. Each day, we must add the current date to an existing table that list the resources (Products) that we handle. That part is simple. I just added a criteria of Date = [Date ?] to the append query.
However, when I open the form which is based on all records, I have to enter the date in the form filter, also. Otherwise I would be looking at hundreds of lines of data that I don't need. Not a big deal, but it would be nice to have the form open up with just the records we have added that day.
I made an Input box for the date but do not know how to put the input into both the query and form.
Is there a way to pass the date to the append query and then the form automatically? (Hope this makes sense!)
Thanks, Bill
 
Hi Bill,

I don't think there is any justification for using parameter prompts in queries. Consider faq701-6763.

If you use a text box on a form, you can set its default to =Date() and use a calendar date picker to choose another date. Plus the same form/text box can be used for more than one task.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Duane, I agree with everything you said. However, we have a receptionist fill these out everyday and she knows nothing about Access. Just trying to make it a little simpler for her.
 
Problem solved. You got me to thinking. Since the date she will be adding is the latest date, I just used the DMAX() function and it works perfectly.

Thank you
 
Apparently "simpler for her" is responding to a parameter prompt [Date ?]? I would expect it could be made simpler but that's just my opinion.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top