Member Avatar for SlyMaelstrom
SlyMaelstrom 5 Newbie Poster

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:

If myTable.thisField[currRecord] == myTable.thisField[currRecord+1] then
   // Run a Query

Does anyone know the VBA code for this? Thanks.

  • 1 Contributor
  • 0 Replies
  • 97 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.