Why is this report not generating the data?

[whitebear]

Hi

On the "CustomerReport" form, the bottom two combo boxes are not generating the report.

It is linked to the query "CustomersViaCustomerName" and have put the scripting into the criteria box under the Last name collum, but the report is blank.

Thanks

 

[dkinley]

The bound column of the combo box is on the CustomerID so this is the only data the query will see. You will need to bound the combo box to the column of the last name. I would also set the view of the combo box to show the last name (and not the first) since this is what the basis the user will be searching on.

-dK

 

[boblarson]

Better yet, I just modified the form to work better. Check it out in my attachment. It has the name concatenated to use for the reports.

Oh, and I didn't have time to do it but you don't need separate queries and separate reports for this. You can do it all with a generic query and a generic report. I'll see if I can't squeeze some time in to show you how later.

 

[whitebear]

thanks thats great. I did feel i was being rapetative in creating many queries.

WB

 

[boblarson]

Here you go - here's your database revised to use only ONE report with ONE query but using CODE to send the WHERE clause to the report when opening. Simplifies matters immensely and keeps you from having to create a query and report for every scenario you want.