Print only new records

  • Thread starter Thread starter Lisa Reber
  • Start date Start date
L

Lisa Reber

Northwind database has a filter (Reads "OrderID>11072") on
print invoices that is "loaded automatically with the
form/report". How'd they do that? I'd like to do this,
specifically send my 'invitation to join' form letter to
newly entered contacts. Currently new entries have "Send
letter = Y" default; then I delete all Y's after the
letters have printed. Obviously it can be done, and
probably should be done that way. TIA!
 
One simple way is to use the WhereConditon argument of the DoCmd.OpenReport
statement that you use to open the Report. The Control Wizard will generate
the code for you, but not the WhereCondition argument. Put the cursor in the
DoCmd.OpenReport statement, press F1, and it will display the Help.

Larry Linson
Microsoft Access MVP
 
Back
Top