How to link a table to a form "mugziegumz" <u47747[ at ]uwe> 11/23/2008 5:39:05 AM I'm brand new with Access. I've made a simple table with Name, Phone, email, company. What is the next step I do to create a form that links to the table so that when I enter info into the form, it'll show up on the table? I see it in all the templates Microsoft supplies but I don't need it that technical. In those templates provided there also is that option to click on the ID number and it pops up a details box/form to enter the info in...how do I create that link to auto open the form? HELP!

RE: How to link a table to a form Daniel Pineault 11/23/2008 1:31:00 PM Take a look at http://databases.about.com/od/tutorials/ss/forms.htm Specifically step 5. -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "mugziegumz" wrote: [Quoted Text] > I'm brand new with Access. I've made a simple table with Name, Phone, email, > company. What is the next step I do to create a form that links to the table > so that when I enter info into the form, it'll show up on the table? > I see it in all the templates Microsoft supplies but I don't need it that > technical. In those templates provided there also is that option to click on > the ID number and it pops up a details box/form to enter the info in...how do > I create that link to auto open the form? HELP! > >

RE: How to link a table to a form "mugziegumz via AccessMonster.com" <u47747[ at ]uwe> 11/23/2008 4:29:56 PM I'm still confused. I'm using 2007. I used the wizard. Where is the option to link the table to the form? Is it in the properties box? I followed the steps on the website but it doesn't specify how to set the link. HELP! Daniel Pineault wrote: [Quoted Text] >Take a look at > >http://databases.about.com/od/tutorials/ss/forms.htm > >Specifically step 5. >> I'm brand new with Access. I've made a simple table with Name, Phone, email, >> company. What is the next step I do to create a form that links to the table >[quoted text clipped - 3 lines] >> the ID number and it pops up a details box/form to enter the info in...how do >> I create that link to auto open the form? HELP! -- Message posted via http://www.accessmonster.com

Re: How to link a table to a form "Pete D." <pduffy211AT[ at ]coxDOT.net> 11/23/2008 4:58:34 PM It is the record source for the form. Select the form, not a control and check the properties for record source. "mugziegumz via AccessMonster.com" <u47747[ at ]uwe> wrote in message news:8da02ed502694[ at ]uwe... [Quoted Text] > I'm still confused. I'm using 2007. I used the wizard. Where is the option > to > link the table to the form? Is it in the properties box? > I followed the steps on the website but it doesn't specify how to set the > link. HELP! > > Daniel Pineault wrote: >>Take a look at >> >>http://databases.about.com/od/tutorials/ss/forms.htm >> >>Specifically step 5. >>> I'm brand new with Access. I've made a simple table with Name, Phone, >>> email, >>> company. What is the next step I do to create a form that links to the >>> table >>[quoted text clipped - 3 lines] >>> the ID number and it pops up a details box/form to enter the info >>> in...how do >>> I create that link to auto open the form? HELP! > > -- > Message posted via http://www.accessmonster.com >

Re: How to link a table to a form "Mike Painter" <mddotpainter[ at ]sbcglobal.net> 11/25/2008 2:02:52 AM Use the form design wizard. mugziegumz wrote: [Quoted Text] > I'm brand new with Access. I've made a simple table with Name, Phone, > email, company. What is the next step I do to create a form that > links to the table so that when I enter info into the form, it'll > show up on the table? > I see it in all the templates Microsoft supplies but I don't need it > that technical. In those templates provided there also is that option > to click on the ID number and it pops up a details box/form to enter > the info in...how do I create that link to auto open the form? HELP!