S
sps
I have a combo box on my form (account #) where the source
is dynamically updated. In addition, the user has a
lookup field that will generatate an account # from a
transaction code. Once this account # is generated, I set
the value of the combo box to that value (the combo box is
bound to the data table where the records are stored).
The prompt is then moved to the next field in the form.
The problem I am having is if the lookup generates an
invalid account number (not in the combo box list) no
error is generated. I have the combo box restrict to list
property set to true, this works if the user types in the
account number but does not work if the account number is
put there progmatically. I need to make sure that the
account number is valid before continuing.
I have thought about running a query with the same
criteria used to populate the list box and then searching
it for the generated account number. This seems like a
long way around what should be an easy problem. What is
the better way to do this?
Thanks.
Steve
is dynamically updated. In addition, the user has a
lookup field that will generatate an account # from a
transaction code. Once this account # is generated, I set
the value of the combo box to that value (the combo box is
bound to the data table where the records are stored).
The prompt is then moved to the next field in the form.
The problem I am having is if the lookup generates an
invalid account number (not in the combo box list) no
error is generated. I have the combo box restrict to list
property set to true, this works if the user types in the
account number but does not work if the account number is
put there progmatically. I need to make sure that the
account number is valid before continuing.
I have thought about running a query with the same
criteria used to populate the list box and then searching
it for the generated account number. This seems like a
long way around what should be an easy problem. What is
the better way to do this?
Thanks.
Steve