Hi Barbara,
>Put the code to change the City combo in the InteractiveChange event of the State combo. Don't forget a requery() on the City combo.<
Thanks for the suggestion.
One question though. Doesn't the InteractiveChange event fire after every keystroke? If so, then this seems like it would make things very slow, doing a requery() after each keystroke.
Maybe it would be better after the user is finished -- say LostFocus?
THanks,
jmu
Best Regards,
Jim Underwood
Apollo Information Systems, Inc.
Houston, TX