If the two tables have no relation, you must want them to appear separately on the form. Create two subforms on a main form, and connect each table to one of the subforms.
HTH, Toby ----- Original Message ----- From: "masuma_tumpa" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Friday, July 29, 2005 7:09 AM Subject: [AccessDevelopers] Record Navigation Thanks Leo, its nice work. I have another important question, how I will connect two table with one form. Here mention that the two table has no relation so that I can make query. Thanks in advance. Masuma > --- In AccessDevelopers@yahoogroups.com, 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 --- End forwarded message --- Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hsvlcer/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122657349/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> 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/
