Getting Index of the current record in an access table

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Reply

Join Date: Oct 2005
Posts: 21
Reputation: SlyMaelstrom is an unknown quantity at this point 
Solved Threads: 2
SlyMaelstrom's Avatar
SlyMaelstrom SlyMaelstrom is offline Offline
Newbie Poster

Getting Index of the current record in an access table

 
-1
  #1
Dec 27th, 2006
I'm trying to make an event procedure in VBA that will compare the same field of two records for a conditional statement. Here is some psudocode of what I want:
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. If myTable.thisField[currRecord] == myTable.thisField[currRecord+1] then
  2. // Run a Query

Does anyone know the VBA code for this? Thanks.
Last edited by SlyMaelstrom; Dec 27th, 2006 at 11:58 am.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC