access 2007 combo boxes
in [Getting Started]
|
From: tonkaplayer on 11 Mar 2010 12:24 Given a form with the fields Make, Model What is the best way to create combo boxes that look up models based on make? Is it a lookup box or would you create a table with the make and model in it? Also can you set the field so the user can type in something not already in the table? Make/Models do change. Not needed a locked field just want to easy user process. What would be the code? Etc. Thanks
From: Gina Whipp on 11 Mar 2010 18:59 tonkaplayer, For part one of your question see... http://www.fontstuff.com/access/acctut10.htm For part two... http://www.databasedev.co.uk/multi-field-not-in-list.html -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "tonkaplayer" <tonkaplayer(a)discussions.microsoft.com> wrote in message news:C50ACCAB-4EC2-42ED-A61E-EABD38B10243(a)microsoft.com... Given a form with the fields Make, Model What is the best way to create combo boxes that look up models based on make? Is it a lookup box or would you create a table with the make and model in it? Also can you set the field so the user can type in something not already in the table? Make/Models do change. Not needed a locked field just want to easy user process. What would be the code? Etc. Thanks
From: tonkaplayer on 12 Mar 2010 15:03 Thanks I will look it over. A little more I a have a form that pulls fname lname for name table. I search using the built in access searfch that is on the botton of all forms. I then have a linked subform, linked by student id. This subform pulls data from acton table recording student parking stickers and car info. This subform has a subform as well that is linked and records citation information. I will lokk over your link more but at first glance it is very differnet from the help one. More that one way to do it I am sure. One last question when I have these combo boxes working can I save the data pulled from the make model tables to the action table? Thanks for the help. "Gina Whipp" wrote: > tonkaplayer, > > For part one of your question see... > > http://www.fontstuff.com/access/acctut10.htm > > > For part two... > > http://www.databasedev.co.uk/multi-field-not-in-list.html > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "tonkaplayer" <tonkaplayer(a)discussions.microsoft.com> wrote in message > news:C50ACCAB-4EC2-42ED-A61E-EABD38B10243(a)microsoft.com... > Given a form with the fields Make, Model What is the best way to create > combo > boxes that look up models based on make? Is it a lookup box or would you > create a table with the make and model in it? Also can you set the field so > the user can type in something not already in the table? Make/Models do > change. Not needed a locked field just want to easy user process. What > would be the code? Etc. Thanks >
From: Gina Whipp on 12 Mar 2010 21:21 I don't think I understood your last question... Why would you want to save the data into another table? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "tonkaplayer" <tonkaplayer(a)discussions.microsoft.com> wrote in message news:890FC0C3-51F6-4557-8C38-69D88AD0C7FC(a)microsoft.com... Thanks I will look it over. A little more I a have a form that pulls fname lname for name table. I search using the built in access searfch that is on the botton of all forms. I then have a linked subform, linked by student id. This subform pulls data from acton table recording student parking stickers and car info. This subform has a subform as well that is linked and records citation information. I will lokk over your link more but at first glance it is very differnet from the help one. More that one way to do it I am sure. One last question when I have these combo boxes working can I save the data pulled from the make model tables to the action table? Thanks for the help. "Gina Whipp" wrote: > tonkaplayer, > > For part one of your question see... > > http://www.fontstuff.com/access/acctut10.htm > > > For part two... > > http://www.databasedev.co.uk/multi-field-not-in-list.html > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "tonkaplayer" <tonkaplayer(a)discussions.microsoft.com> wrote in message > news:C50ACCAB-4EC2-42ED-A61E-EABD38B10243(a)microsoft.com... > Given a form with the fields Make, Model What is the best way to create > combo > boxes that look up models based on make? Is it a lookup box or would you > create a table with the make and model in it? Also can you set the field > so > the user can type in something not already in the table? Make/Models do > change. Not needed a locked field just want to easy user process. What > would be the code? Etc. Thanks >
|
Pages: 1 Prev: Link Items in Same Table Next: Microsoft Office Access an't find the object '[.' |