Reference Column to Row in VB

[bugzLue]

Can anyone help me with VB code for Access or SQL?
I need to be able to reference one column to the primary column and output the row from the primary column.

so if po_id is 2 then it will go over to ID column look for 2 and row 2 prints out.

ID (PK)

PO_ID
PE_ID

ID Name Address CSZ PO_ID PE_ID
1 Bla bla 123 bla Any 999999 1 4
2 Ha HA 234 ha Mine 88888 1 3
3 ME me 345 City NY 11111 2 1
4 See 456 SD Ca 99211 3 2


Thank if you can help Live to learn or die trying

 

[ufobaby]

ummmm ... if i understand this right then

'---- 1st select stmt

Set rs = db.OpenRecordset(Select * from <<table>>)

'--- loop through records
Do while rs.EOF = False

if rs(&quot;po_id&quot = &quot;2&quot; then

Set rs = db.OpenRecordset(Select * from <<table>> where id='2')

'=== here u can print or write to a file etc in a loop
end if
rs.movenext
loop

this above code is assuming u know DAO and stuff
else write back


Niraj