John Bartow
john at winhaven.net
Wed Sep 30 01:44:15 CDT 2009
What is the syntax to set a variable to a field's value in the current row of a recordset? ---------------------------------------------------------------------------- -- Private Sub PrintAllReports() 'Loops through AddressData table and prints all customer reports Dim db As Database Dim rs As Recordset Set db = CurrentDb Dim lngAcctNum As Long lngSum = 0 Set rs = db.OpenRecordset("SELECT * FROM AddressData ORDER BY TrayNumber") Do While Not rs.EOF 'set variable to lngAcctNum current AccountNumber field to use as filter in each report lngAcctNum = 'Print Report 1 using: AccountNumber = lngAcctNum as report filter 'Print Report 2 using: AccountNumber = lngAcctNum as report filter 'Print Report 3 using: AccountNumber = lngAcctNum as report filter rs.MoveNext Loop rs.Close End Sub ---------------------------------------------------------------------------- --