Acme Oil and Gas error when setting the limit to list property

Asked By Bob T Smith 35 points N/A Posted on - 09/18/2013

Hi,

I just set the limit to list property as ‘Yes’ but I received the following error message saying “Sorry, I cannot accept that entry. Please choose an item from the list”. How can I avoid this annoying error message? Have any idea to fix it? Any help would be appreciated. Thanks.

Acme Oil and Gas

Sorry, I can not accept that entry.

Please choose an item from the list.

• Status: Open
• Question Views: 474
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others

Answered By Padilla Maillet 5 points N/A #194017

Acme Oil and Gas error when setting the limit to list property

If you want to avoid this message, one thing you need to realize is that access recognizes an entry that matches all the items in the combo box list. Therefore,  in order to override this do the following:

Set the limit To List property of the combo box to “yes” so the form can accept any non matching query

Add the new item to the list so the form can accept any non matching parameter.

About Padilla Maillet

Questions
0

Answers
13

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/19/2013
• Question Category: Software Others