VBA ACCESS table

[joanas]

I have this table:



Concept Priority Center
0003 1 1020
0003 2 6500
0003 3 6900
0004 1 1020
0004 2 6500
0010 1 6700


i want to do something like this:

every time he finds the first record, and if priority is "1" appears a msgbox with the center

and when finish move for the next concept


but i dont want to specify the concept "0003" because sometimes the table change and i have others concepts..

can you help ? thanks

[ranman256]

I'm not sure what youre asking. Why not filter out priority 1?

[joanas]

because i just want to do that for the same concept - iin this case "1020"