Thanks Leo, its nice work.
I have another important question, how I will connect two table with one form (MS Access). So that I can show one table data in the form and after modification I want to save the data plus some text box data to another table. Thanks in advance. Masuma --- In [email protected] , Slimey Hom <[EMAIL PROTECTED]> wrote: > masuma, > > try use recordsetclone. See example below: > > > me.recordsetclone.findfirst "IDNdx = " & yourIDVariable > me.bookmark = me.recordsetclone.bookmark > > Remember: > 1. Make sure that your form is bound to the table you want to search. > 2. make sure that IDNdx is you primary key on that table. > 3. All your text boxes or other objects are bound to certain field on that table (for you to view the result) > 4. to test the code, put it in a command button having a Click event. then either the yourIDVariable came from a text box or from inputbox... > 5. try it and you can navigate anywhere in your table by using ID key. > > eNJOY!!! > > > > ---->>> "mABuHaY AnG pInOy!!!...!!!" <<<----- > > > > > > masuma_tumpa <[EMAIL PROTECTED]> wrote:Hello all, > > Can any body help me? Say I have 1000 record in my table. Now I want > to display in my form the 150th record or I want to show the record by > specific id no/name. Please let me know the configure and code (VB) in > Access. > > Thanks in advance > > Masuma Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
