How to consist this loop?
Posted on 2002-05-17
In my project, I have 2 Access 97 tables (T1 & T2), every one contains only 5 records and one field “F1”. Please I need the LOOP Code which makes me fill “F1” in the record (1) of “T1” by the world “RED” THEN fill “F1” in the record (1) of “T2” by the same world … Then fill “F1” in the record (2) of “T1” by the same world THEN fill “F1” in the record (2) of “T2” by the same world … and so on till the EOF (I mean going between the 2 tables once here and the other there …..till EOF)
Sirs, I know how to use ADO and how to fill the records. I want your help to show me the LOOP code which makes my request mentioned above.