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
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