fill cbo from input into txtbox

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
 

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