Simple problem of combo box

R

Rex

Hi,

I have access 2000 as front end for SQL server 2000. On the form I
have a combo box which lists values from a table. The problem is I
want to restrict user from entering only the values in the drop down
box.

Any help will be greatly appreciated.
Thanks
 
G

Guest

Hi Rex,

Two possible issues to check that I can think of:

1. There is a 'limit to list' property of a combo box. Open the form in
design mode, select the combo box by left clicking it, open the properties
window (hit the 'f4' key), and look on the 'data' tab (I think) for something
that says 'limit to list'. It should be set to 'yes' if you want to restrict
users to the choices in the combo box.

2. The other issue, and this would only be an issue if you or someone else
made it one, is that even with the 'limit to list' property set to 'yes',
users can add new items to the combo box list IF there is code in the
'NotInList' event of the combo box. To check for that, look on the 'events'
tab of the combo box (while the combo box is still selected, click on the
events tab and find the event).

If it says something in the space beside the "NotInList" event, for example:
'event procedure', then there's some code (or possibly a macro....depending
on what it says) that is running when the user types in a choice not in the
list and attempts to move to another control on the form. I THINK you can
just delete what it says beside 'NotInList' and the code/macro won't run
(even though you haven't deleted the underlying code/macro itself).

Hope that helps,
CW
 

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

Top