OnChange fires with every keypress, but the combo can't check to see if the
selection is valid until the user tries to exit the control, because, of
course, you can't enter XYZ without entering X - Y - and Z, and the entry
isn't valid until the last character is typed.
You probably want to use the AfterUpdate event instead of OnChange - that
event won't fire until the user has actually picked a valid selection from the
list. Also, if Access wants you to have the focus on a control to read its
value, that might mean you are trying to use the .Text property to read the
value rather than the .Value property. In Access, .Text is the text that is
displayed in a control while an edit is in progress, and is only available
when the control has the focus.
On Tue, 20 Apr 2004 15:53:55 GMT, "Danny" <da********@hotmail.com> wrote:
I have a combo box look up and list items in a table, it is not bound.
It works fine but how can I prevent the users from entering in there own
data?
i have an 'on change' event that when it changes, it does something else to
a field based on their selection.
I also have the LimitTOList on, but when they click in there, they get an
error first that says the
2110-focus cannot move the focus to this control. (I have the .setfocus
command becuase access wants the focus set to a control when getting data
from it)
SO, why would they get an error?
what to do?