Automatic Field Refresh

[Guest]

I have a form, which contains fields that autopopulate a dropdown according
to information in another field on the form, For example:

If I enter Math in the Department Field the drop downs for Faculty will
popluate with the names of Math Faculty.

Now my Problem is that as I switch records the dropdowns don't automatically
refresh to pull for whatever I put in the next department Field- I have to
manually go to the refresh in the Records Menu.

Does anyone know how to automatically refresh my field as I toggle between
records in my form? Thanks!

 

[Al Camp]

Try using the OnCurrent event of the form to trigger a Requey of your combo box.
Also, you should have a requery on the AfterUpdate event of the Department field.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
There are 10 types of people in the world.
Those who understand binary, and those who don't.