I wrote some code in VBA to be able to select dependent records on a form B
when I select a record on form A (very classical)

I worked just after writing it !
but after closing the general form containing the forms A and B
It doesn't work anymore !

what a frustration working with this stuff!

here is the code
I don't really which event I should use !

but Form_current seemed to work! at first

<code>
Private Sub Form_Current()
Form_B.RecordSource = "SELECT * FROM TableB where Valeur='" & codeA & "';"
</code>

which lies within the Form_A codes !

any help welcomed