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. Please let me know the configure and code (VB) in
Access.
Thanks in advance
Masuma
__________________________________________________
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
- 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.
