I'd like to create a form that looks up info in a query that has three fields (date, department, sales volume) The form would have a combo box to select department, text field to enter the date and the third box would automatically populate the volume based on the criteria in the other 2? Anyone have suggestions on how to do this?
Thanks.
bluke
Thanks.
bluke