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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update table from form 7
Combo box 0
List box loads slowly first time but quicker on subsequent requerying 0
Data entry for a table from a form 1
Data Entry VBA 4
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
"Cannot open any more databases" 10
Unbound combobox invalid datatype error 6

Top