Access Help - Populating code from list of data

[nzkfc]

Hi guys,

Hoping I can get some help here.

Background is I have two sets of data, one a list of a simple set of ID's (one ID per line) and I have a piece of repetitive coding that needs one of the lines inputted into a place in the code (hope that makes sense.

An example:


(List of data)
01-12345
02-12345
03-12345

(Code block - ignore code lol it's made up)

<check>
("<code here>")
if () then
finish
</check>


So once the "whatever" method is used, I will end up with a code that looks like this:

<check>
("01-12345")
if () then
finish
</check>

<check>
("02-12345")
if () then
finish
</check>

<check>
("03-12345")
if () then
finish
</check>


Let me know if I'm not making sense :P my experience with Access is null :P

Cheers!

[pbaldy]

Presuming you mean a table for the list, you can open a recordset on it and loop that table, using the current value in your other code. Hard to be more specific with seeing how you actually want to use it.

[June7]

So you don't have code, just an idea for code?

You need VBA?

What do you mean by 2 sets of data - 2 tables? What exactly do you need to do? What is it you want this code to accomplish? Do you want to update records? Do you want to find matching records?