Query criteria/filter question

[chris_jolly]

Hi all,

I am designing a database that is completely input driven. This is my first database so because of the reliance on the user to populate everything it has been rather confusing.

I have a query that I have set up that uses 3 selections, 2 from a combo box, and one from a text box to populate 3 distinct fields. In this case its a Plant #, a Material #, and a Version # (version corresponds to another report that this tool will serve as an input towards). After these are populated, the user will be manually inputing information for 24 versions after the current version.

My question is how can I go about referencing what I have in the Version # on the query, or the combo box for that matter?? I need to reference the current version selected than have it display only versions 2 years out.

fyi - I have a table with 5 years worth of versions(technically months) in my main table. Could I reference those?


Also, would it be easier to include every single version that I already have stored and just filter for the 2 years out??


Thanks for the help

 

[ajetrumpet]

My question is how can I go about referencing what I have in the Version # on the query, or the combo box for that matter??

The basic reference for form controls is...
Forms![form control]![control name]

If you are referencing a control with any type of dependency (criteria) on other data, this is specified in the WHERE clause of the query.