Thanks Leo, its nice work. But if I want to navigate by other than primary key then waht I have to do?
I have another important question, how I will connect two table with one form. So that I can show one table data in the form and after modification I want to save the 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 > > > > > > > Please zip all files prior to uploading to Files section. > > > > SPONSORED LINKS > Microsoft access database Free microsoft access database Microsoft access developer Microsoft access Microsoft access database design Microsoft access database training > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "AccessDevelopers" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
