J JohnLee Registered User. Local time Today, 07:45 Joined Mar 8, 2007 Messages 692 Oct 15, 2010 #21 Hi vbaInet, Thanks for that, that solved the problem, I didn't think about the count variable, but it's one I won't forget now. Cheers John
Hi vbaInet, Thanks for that, that solved the problem, I didn't think about the count variable, but it's one I won't forget now. Cheers John
V vbaInet AWF VIP Local time Today, 15:45 Joined Jan 22, 2010 Messages 26,374 Oct 15, 2010 #22 To be honest, you only need just one variable for the counting. Glad you've got it sorted.
J JohnLee Registered User. Local time Today, 07:45 Joined Mar 8, 2007 Messages 692 Oct 15, 2010 #23 hi vbaInet, I took your advice and removed the "RecordsCount" variable and assigned the "count" variable directly to the "rst!lngRecordCount field". All is working fine. Thanks for your help once again John
hi vbaInet, I took your advice and removed the "RecordsCount" variable and assigned the "count" variable directly to the "rst!lngRecordCount field". All is working fine. Thanks for your help once again John
V vbaInet AWF VIP Local time Today, 15:45 Joined Jan 22, 2010 Messages 26,374 Oct 15, 2010 #24 No problemo JohnLee!