PORNOLATION RELEASE

"Jeff Boyce" msn.com-DISCARD_HYPHEN_TO_END> wrote in message
news:uTdr07WOHHA.4172@TK2MSFTNGP03.phx.gbl...

Yup. Thanks for that. Have messed about and got the filtering working great.
Thanks for your help.

As a side note, I have an 'embedded form', if you wish, which allows images
to be saved against said property. This doesn't appear to remember the image
when you exit the record and go back to it, but when you view
frmPropertyImages, there is a list of images I've tried to save. Odd?

I have a drop down list which I'd like to use to filter the records within
the form. The drop down list contains a list of managers who are responsible
for certain buildings.

I'd like to select a managers name, then the records shown within the form
are those which are related to said manager.

I have a table called tblProperty which contains the building names. There
is also a table called tblManagers for each manager. tblProperty has a field
ManagerID, as does tblManagers. I have setup a relationship between the two
ManagerID fields. Correct?

What I'd like now, is to select the manager and perform a query which will
display the records related to this manager.

I'm thinking that some form of event code is needed for After Update?

Any hints or tips would be much appreciated.