Form to Run a Query

[JDubs84]

I am very confident with tables and queries but just now experimenting with Forms and Reports. I have Access 2003 at work.

I am trying to make a form that runs a query. I am able to make a combo boxes that I can enter a single value and it produces the desired result. I need to make a combo box that would allow me to enter a date range or >=#1/1/2012#.

Is this possible?

Thanks
Jared

 

[dhookom]

I'm not sure why you would use a combo box for a date entry. You would typically use a calendar. I guess I have used a combo box for selecting special financial beginning of month type dates.

You can reference these controls in queries just like text boxes. Your criteria might be something like:

>=Forms!frmYourFormName!cboBegDate

Duane
Hook'D on Access
MS Access MVP