combobox allowing entry not in list tina 11/20/2008 1:38:01 PM Hi I have a combo box on form data2 with following in row source SELECT [detail].[LotJob] FROM detail WHERE StockCode=[Forms]![Data2]!StockCode; This works but if type in combo box this is accepted even if not in list as there are lots of lotjob against stockcode would like to be able to enter lotjob but only accept if in list Thank you Tina

Re: combobox allowing entry not in list "tkelley via AccessMonster.com" <u47368[ at ]uwe> 11/20/2008 1:44:54 PM What is in the LimitToList property of your combo box? tina wrote: [Quoted Text] >Hi >I have a combo box on form data2 with following in row source >SELECT [detail].[LotJob] FROM detail WHERE >StockCode=[Forms]![Data2]!StockCode; >This works but if type in combo box this is accepted even if not in list >as there are lots of lotjob against stockcode would like to be able to enter >lotjob but only accept if in list >Thank you >Tina -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1

Re: combobox allowing entry not in list tina 11/20/2008 3:02:01 PM Thank you Sorry to waste your time I am having a bad day set LimitToList property to yes works "tkelley via AccessMonster.com" wrote: [Quoted Text] > What is in the LimitToList property of your combo box? > > tina wrote: > >Hi > >I have a combo box on form data2 with following in row source > >SELECT [detail].[LotJob] FROM detail WHERE > >StockCode=[Forms]![Data2]!StockCode; > >This works but if type in combo box this is accepted even if not in list > >as there are lots of lotjob against stockcode would like to be able to enter > >lotjob but only accept if in list > >Thank you > >Tina > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1 > >