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

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

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.