Hi all

I'm struggling with VBA at this stage.
I've got Access as frontend and MySQL as backend trying to do the following.
I have a table with fields such as part# and order#.
What I want to do is for each row with the same order# (approx 100 records)I'd like to run an update query on a 3rd field, using the part# field as criteria in my update query.
My problem is understanding the Do Loop function and also connection properties.

So far I've only used VBA to run action queries and some easier code but I'm stuck at this one.

Any help would be greatly appreciated.

Cheers / Fred