Diplaying picture on the form

[janie66]

Hi guys
Can anyone please help me out i need to display image on form .i have a requirment
iam pulling data from query...

PRDID PRDNAME PRDPIC
01 XYX product1.JPG
02 ABC product2.JPG

My requirment is when i click the button ..it will display the images on below each other
iam doing this,please correct me

private sub cmd_click()
dim sql as string
sql ="select prdpic from query
dim rst as recordset
set rst=new recordset
rst_sql.open sql,currproject.connection
picture=rst_sql!prdpic
me.image1.picture=picture
me.image2.picture=picture

on both images..the same picture is displaying.. i need to display AB.JPG on image2.....
Thanks in advance

[NeoPa]

When you execute the line
me.image2.picture=picture
'picture' is still set to the image from the current record of the recordset.
You need to execute something like
rst.MoveNext
to set the new current record then assign the picture.

Something like

me.image1.picture=rst!prdpic
Call rst.MoveNext
me.image2.picture=rst!prdpic

[janie66]

thanks for the response..i tried to use
call rst.movenext
but it is still displaying the same pictures

[NeoPa]

I'm a little confused then.
Perhaps you could cut and paste the actual code you're currently using into this thread for a thorough check through.

An idea of which tables store which data and which dataset (if any) the form is bound to would also be helpful.

[janie66]

Thanks NeoPa
It is working fine now.i've checked the table and query bound to the form... thanks for ur help......
Thanks again!