to retrieve records in vb based on primary key value

[kirthica]

Hai friends could you help me?

In VB if i've connected ms access project through a data control to my form..... and i've added many records to my database... and I've set "yarn no" as my primary key... if later I've to update my stock details... I need to retrieve the data s from the record once i've entered the yarn.no (i.e)primary key value....
so can anyone help

[jireh]

Do you mean a query that will retieve the data you recently added? if that's the case hope this would help...

" SELECT  *   FROM [<em>tablename</em>]   WHERE   Yarn_No = '" &  txtYarnNo.Text  & "'  "

[debasisdas]

you ned t open the recordset by passing the primay key value at runtime as suggested in the previous post.