for next question

[rmh3619]

I have a table called "customer" with a field "customer_name"

i want to execute code for each customer_name in the table. (e.g. msgbox customer_name)

how can i do this. i think i should use a for / next statement but I dont know how.

Thanks

 

[jdgreen]

What kind of code do you want to run? What I'm reading is you want a message box to come up for each customer?

John Green

 

[BSman]

Assuming you actually want to do something and not display a message box each time, there are a number of ways to do it.

If you want to update values in one or more columns in an associated table you could create an update query (or even more than one update query). There are a lot of things you can do in queries, even some fairly complex things, so that's probably the best way to go.

If you want to perform a lot of operations for each customer, then you probably need to create a recordset of the customers and loop through the recordset so you get all of the customer numbers. For each customer execute all the code you want.

Bob

 

[missinglinq]

I think you need to be a lot clearer on what you're trying to accomplish if you want us to help.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!