Continous form with combobox

[ReidarT]

I have a continous bound form with a combobox .
The combobox has a rowsource with a WHERE -clausul like the value in a field
on the continous form.
Example:
Table 1
Field1 - number, Field2 - number, Field3 - combobox

Table2
Field1- number, Field2 - text

The rowsource = SELECT Table2.Field1, Table2.Field2 FROM Table2 WHERE
Table2.Field2 = Table1.Field2

This seems to work when opening the continous form, but I can't get it to
change when I click on the next row in the continous form.
I have tried refresh and requery in the code, but it doesn't seem to have
any effect

regards
reidarT