restricting records in a combo field in a data***

hi

I have a data*** which is a subform. I have fields Client,Contacts
and VisitDate in the data***. What I want is to be able to update my
Contacts field to only show the contacts that are in the Client.

I have an afterupdate on my Client field to only show those Contacts
which works for that record only. However when I choose different
records it keeps showing only the contacts for the last Client I
updated.

Is is possible to only show those Contacts that relate to the selected
Client in a data***.

thanks

Shumit

.