J
JohnE
Hello. This is going to be a peculiar issue but the db was done long ago by
someone else on a dark and drury night and this is a request from the users.
I have a form with a txtbox that has zip codes entered into it. On the same
form there is a cbo that has a query for a rowsource. This rowsource only
has 7 items to it that provides a regional code to the field based on the
zipcode entered. There is a table that has the established zipcodes and
corresponding regional code. There can be instances when the user enters a
zipcode and there is no corresponding zip code. There are also times when
the user will enter a zipcode and the cbo will then display the corresponding
regional code.
My issue is how do I get the corresponding regional code into the cbo when a
zipcode is entered into the txtbox field?
I am trying the On Exit event of the txtbox.
Thanks to anyone responding with assistance.
.... John
someone else on a dark and drury night and this is a request from the users.
I have a form with a txtbox that has zip codes entered into it. On the same
form there is a cbo that has a query for a rowsource. This rowsource only
has 7 items to it that provides a regional code to the field based on the
zipcode entered. There is a table that has the established zipcodes and
corresponding regional code. There can be instances when the user enters a
zipcode and there is no corresponding zip code. There are also times when
the user will enter a zipcode and the cbo will then display the corresponding
regional code.
My issue is how do I get the corresponding regional code into the cbo when a
zipcode is entered into the txtbox field?
I am trying the On Exit event of the txtbox.
Thanks to anyone responding with assistance.
.... John