Need To Loop Thru Tbl1, Update Fields & Based On Data Update Tbl2,Tbl3

[ReportMan]

I am really a FoxPro developer instead of Access and I have done this many times before in FoxPro but can't figure out the code required in Access. What I need to do is loop thru Tbl1 updating certain fields based on other fields content, then while still on the same Tbl1 record lookup a Tbl2 and Tbl3 record and update some fields there.

I would prefer to do do this in a controlled loop and not thru a query. Can someone give me a hand with this? Any help would be greatly appreciated.

 

[WildHare]

The fact that you want to do this "in a controlled loop and not in a query" confirms that you are a FoxPro developer...

Don't fight it. Do it in a query. That's why they invented them - so a couple dozen words in SQL can replace 100 lines of code....

If the database is designed correctly, this should be a snap with a correctly joined domain in an update query.


Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm