Query to linked value in other table

[gazza110]

I have a table called "Resources" that has a field "Reference". In another table called "Authors" I have "reference" also with another field "author" this links the 2 together. From a form I want to open form "frmResources" and filter to an author that I have selected from a unbound combo box. I have a query that has a creteria to match the author name and this shows the relevant reference numbers. However when opening a form using filter it still displays all the records and does not filter. It seems such a simple thing but I can't seem to master it !!!!

Please can you help,

Gary.

 

[lynchg]

What is the source of data for your authors combo box? The values in the bound column of your combo box need to correspond to the to the field in the authors table that you are using in the criteria field of your query.

My guess is that there is some disconnect in there somewhere.