rick roberts
Registered User.
- Local time
- Today, 23:41
- Joined
- Jan 22, 2003
- Messages
- 160
i have a form that contains records regarding overdue payments and a button that prints a letter to all records on that form - this works fine. i want to add another command after the printing command to tick a box indicating that a letter has been sent but when i add the command (straight after the print comand) it only ticks the first record - it doesnt seem to stay within the loop. ive tried just using the tick command on its own with the same result so i guess the problem is the way im commanding the tick? CheckLetter1 being the tickbox in question. any suggestions please? thanks in anticipation.
'If only one record
If reccount = 1 Then
DoCmd.OpenReport "rptOutstandingLetter1", acViewPreview
Exit Sub
Else
a = 1
Do Until a = reccount
DoCmd.OpenReport "rptOutstandingLetter1", acViewPreview
CheckLetter1.Value = 1
a = a + 1
Loop
DoCmd.OpenReport "rptOutstandingLetter1", acViewPreview
End If