Query in subform, how to use a field from main form?

[Snecia]

Hi there,
I have a query in my subform:

SELECT ContainsTracks.albums, ContainsTracks.tracks
FROM ContainsTracks
WHERE ContainsTracks.albums LIKE [VALUE IN TEXTBOX1 FROM MAIN FORM]

As you can see in the brackets, I would like to use the value in textbox1 on my main form in this query (so I can select only the tracks from the album that is typed in textbox1, disregarding the others).

How can this be done?

Thank you for your time guys,

 

[pr2-eugin]

Try..

Forms![yourFormName]!TextBox1