View Full Version : VBA: Newbie question

08-14-2008, 01:57 PM
Hi everyone,

Sorry if this is the wrong area to post about VBA questions, but I couldn't really find anywhere else within the forums :)

Basically I'm playing around with VBA in...Access 97 :|

...just....don't ask.

Anyway I want to loop through a table and compare two columns against each other in a function I've already made and tested.

If someone could give me a snippet of what I'm looking for i.e.

for each row in table
if row("col1").text = row("col2).text then
'do this....
end if