combobox allowing entry not in list

T

tina

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
 
T

tkelley via AccessMonster.com

What is in the LimitToList property of your combo box?
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
Click to expand...
 
T

tina

Thank you
Sorry to waste your time I am having a bad day
set LimitToList property to yes
works

tkelley via AccessMonster.com said:
What is in the LimitToList property of your combo box?
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
Click to expand...
Click to expand...
 
Top