any idea's

[teiben]

I have a frm, which has a list of "departments" in list box, when one is selected a report opens, which is based on a query. The query runs the the following:

[forms]![frmListByDepartment]![mylistbox] becuase I also need the date rangine ON the report I've added: Between [Beginning Date] And [Ending Date].

Now the users want to use the ActiveX calenadar and the frmlistbox. (two forms). I've tried to combine the caledar and the list box, but when the report is run "it says it's to complex to be evaluation". has anyone done something like this? or have any ideas

 

[Dave Eyley]

If I was doing this...

I would place the calendar and combo on the same form...

Then the user could select the relevant department....so far so good.

Then they would click on the start date (in the calendar) and action would transfer the start date to a field (say Date1) if the field Date1 was Null


Then the they would click on the calendar date again on the end date which would transfer to the second date field (Date2).

The code would test to see if Date1 was already filled and then go on to Date2

Then your query would have all the info to print the report?

Does that make sense?

Of course you could drop the calendar and let the user enter date2 and Date2 directly into the fields...

HTH

Dave Eyley