Appending to a Combo Box

[cotri]

In a form for taking orders I use a “combo Box” for the Zip Code Field and this will populate the City and State using a “select Query” and a Zip Code table. I use this to save time taking orders and it also matches the correct city to the Zip Code that matches UPS software records to prevent hang-ups with their software and address correction charges. Many of the orders taken use this form for inputting but some come from another access database and linking tables and then appending my original table. When the table is appended the Zip Code is appended but I do not append the City or State because I want to take those from my Zip Code table. The problem is the Zip Code is appended but I do not get the City or State look-up. There is a “Tab Stop” for this Zip Code field so I will be tabbing through this field. There are also fields in the imported records that wont be in the records that are created in this form so if it would help one of these fields could be checked for Null to show where the record is coming from. Anybody have any ideals here. Thanks

[RuralGuy]

Not quite sure what you need here. Care to state the issue in another way?

[cotri]

Not quite sure what you need here. Care to state the issue in another way?

For about 7 years I have been using a Access database for taking mail orders. I have the form set up so when I input the Zip Code it automatically fills in the City and State from a table. Now I am also taking orders from Ebay sales. I import data from ebay and link the tables with no problems. There is no City or State field in my main table because it looks it up in the table from the Zip Code. When I link the tables I use only the Zip Code and that works fine but it does not look-up the City or State. If in the form I delete the Zip Code and re-enter it then it will look-up the City and State. Another problem that may be related is I have a couple of fields that are set up with “default” values and they are not being updated. All of these problems are only with the imported records. I hope that makes more since. Thanks for any help

[RuralGuy]

I think I understand. When you look at the imported records with your form, the "automatic" fields are not being completed. It sounds like the "automatic" fields are being completed in the AfterUpdate event of each control. Try adding similar code in the CurrentEvent of the form. That should complete existing records as well.

[cotri]

I think I understand. When you look at the imported records with your form, the "automatic" fields are not being completed. It sounds like the "automatic" fields are being completed in the AfterUpdate event of each control. Try adding similar code in the CurrentEvent of the form. That should complete existing records as well.

Thanks for the help here. This is starting to make since but I cannot find CurrentEvent. I see BeforeUpdate and AfterUpdate in the priorperties for these fields but no CurrentEvent. I see the code for AfterUpdate. I looked in the ”Control Source” of these fields but again don’t see CurrentEvent. As far as the fields that have a Default values, that default was set in the properties under “Default Value” and there was nothing under AfterUpdate. For these I found I could just set the default value in the table so they are not too much of a problem. Will I find CurrentEvent in Access 2000? Why do these updates not take place as I tab through the fields with updates? Thanks

[RuralGuy]

Only a form has a Current event, not a control on the form.