combobox allowing entry not in list

  • Thread starter Thread starter tina
  • Start date Start date
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
 
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

Query suggestions - sub totalling 3
update query using like criteria 3
Need help with "dLookup" function. 2
How to apply a conditional Select distinct (or conditional Where onduplicated cell values in a colum 3
Need combo box to refresh when moving to new record 2017 1
Requery does not refresh values 3
Requery does not refresh values 1
Formatting combo box drop-down list 1

Back
Top