Re: 2 combo boxes

When you choose a Monday date, you can always get the Friday date by adding
4 to the Monday date. You can use this fact in your situation and eliminate
the second combobox.

Assuming your form name is MyForm and the name of the first combobox is
MyMondayDate, put the following criteria in the MondayDate field of your
masin query:
Forms!MyForm!MyMondayDate

and put the following criteria in the FridayDate field of your main query:
DateAdd("d",4,Forms!MyForm!MyMondayDate)

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx



"cager" <cagerama@xxxxxxxxxxx> wrote in message
news:4F3E5C3D-16DB-4AEF-A65A-45C8C2155507@xxxxxxxxxxxxxxxx
I have a query that when run shows 2 fields. Week begin dates (always the
Monday date) and week end dates (always the Friday date).

I want to link one combo box to the week begin date and depending on which
Monday date I chose I want the 2nd combo box to automatically pull the
corresponding Friday date for that week.

I'm not too good with SQL so any help would be greatly appreciated.

These 2 dates would then be referenced in my main query and that query
would
run based on those 2 dates in the combo boxes on the form.

Thanks in advance for you help.


.

Loading