Calling certain columns in a query via a form?

[bluke]

I have a query with 3 fields, department, date, TotalSales. I need to build a form where the user can select the department from a combo box, enter the date in a text box and based upon these criteria, display the sales volume in the 3rd box on the form. I guess you could call it a lookup, but i'm not quite sure how thats done or what the best way to accomplish this. Any help would be greatly appreciated.

Thanks.

bluke

 

[boblarson]

I would just have the first combo select the department, have another combo that displays the available dates based on the selection of the department and in that combo's recordsource you can include the totalsales and then in that combo's after update event put:

Me.YourTextBoxNameHere = Me.YourComboBox.Column(1) to display the total sales for that date.

There is a cascading combo sample here that might help:
http://downloads.btabdevelopment.com/Samples/combos/CascadingCombosSample.zip