View Single Post
  #2 (permalink)  
Old December 23rd, 2003, 09:45 AM
lrickett lrickett is offline
Registered User
 
Join Date: Dec 2003
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I fixed my own problem by doing the export a different way. I used an event procedure on a form called Month:

DoCmd.OutputTo acQuery, "qry_month", "MicrosoftExcel(*.xls)", "D:\Recertifications.xls"

However, now I need to filter this data to a particular month the user chooses in a control(Combo26 which lets the user choose a month) on a form (Month).

In qry_month which is getting exported, I created a field called RecertMonth which returns only the month of the expiration date. In the criteria for this field, I used:
[Forms]![Month]![Combo26]

I thought this was correct, but I get the following error:

The action or method is invalid because the form or report
isn't bound to a table or query.

I attempted to make the control bound, but that resulted in nothing being exported. Any suggestions on where I am going wrong?
Reply With Quote