Thanks, But if the two table has no relation then how I will connect two table with one form?
Thanks in advance. Regards Masuma --- In [email protected], Øystein Frostad <[EMAIL PROTECTED]> wrote: > You must make a query based on the two tables. Then link the query > to the form. > > Use query-wizard. The query you then is make should be linked > together with one of the variables that is simular. So if you have a > table of all the Orders, one of the Variables will be a custommers > ID that was making this order. Then simply link this Order- Custommer- > ID to the ID-nr of your other Custommer table. You do this by > pointing with the mouse, hold the left mouse button down, and lift > the variable to the simular Variable on the Custommer table. An > arrow will indicate the link. (If you then right-click on the arrow, > the joint property of the link will show up. Use the nr 2 link, so > if you have bad info in your table, you will see the Reckord anyway > VARY IMPORTENT, ALWAYS DO THIS) > > If you do this right, then every time you look at this order, you > also have access to the custommer information. > > This is importen stuff to lear. You must make this work. This Query > linking is also nice to use on a list. > > OK? > Stein > (sorry, about some bad english.) > > > --- In [email protected], "masuma_tumpa" > <[EMAIL PROTECTED]> wrote: > > 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 Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h368arb/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1122623187/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> 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/
