Search results for query: *

It displayed the list of contract numbers, and the field contract_number is in the report. It seems to me that the filter is not actually being applied to the report--is this possible? I don't know that it makes a difference, but this command is set to run "on click" anywhere in the report.

Still no dice... with acViewPreview, no records show up on the report. with acviewNormal, all records appear on the printed report, and it prints a number of times.

Dim RS As DAO.Recordset Set RS = CurrentDb.OpenRecordset("fixed sales") While Not RS.EOF DoCmd.OpenReport "fixed sales", acViewNormal, , "[Contract_number" = RS![uct_contract_no] RS.MoveNext Wend

I have been trying for the last couple of days to get this code to work, but I still can't get it quite right. It keeps putting together a report that includes all the clients still, rather than a number of different reports. I even tried hard entering the indentifier in the <client key in...

lameid- is there a way I can modify the code so that rather than needing to manually enter the client key it will use a findnext or some other command to fill that in?

I am using Access 2007 to generate monthly sales reports for a number of different clients. The report is drawing form a query that shows pulls up all current (not expired) contracts that had activity on them in the last month. Right now it puts all the clients into one report, which I can...