Tasks Statistics Question

[SoxPats83]

I have a dilemma that is really driving me crazy. i have a DB that the users will be inputing data into based on the a couple different results for each task. for example. if the user completes the task they will select an option within an option group (values 1, 2, & 3) and the user also makes a selection in another option group specifying what type of task it is (values 1, 2, & 3). each task has a date assigned to it (many duplicates). what i am trying to do is create a seperate form where an admin will open, type in the desired date, and the form will populate many text boxes displaying stats for that date. i understand the whole making unbound text boxes and building the expression in the control source to do the math. my problem is that i cannot find out how to create a filter that when the date is selected in an unbound text box, the information is then filtered to this new form.

 

[vbaInet]

This might be what you need:

http://baldyweb.com/wherecondition.htm

 

[SoxPats83]

i appreciate it, but this does not seem to be doing the trick for me. If i made a copy of the Tasks form that i use on a daily basis (which pulls its data from a query that pulls from a table and filters many many many records so that only the current date's tasks are presented) and removed the record source from this copied form, i would like to then have a box where the user can input the desired date, and then only the records from that date are presented, as opposed to the one i have now where t only shows the current date.

i may have gone on too long there and i assume i am making this much more difficult then it has to be.

 

[vbaInet]

So basically you want a search form? I thought your initial idea was to open another form based on a date?

 

[SoxPats83]

either/or would work

 

[vbaInet]

The following link is for a Search Form. There's a database attached at the bottom of the page and on the next page is an explanation of how it works. See if you can follow it:

http://baldyweb.com/BuildSQL.htm