filtering /w query

[wshm]

I have a continuous form "frm_DeptBudget" (tbl_DeptBudget)
when user clicks a textbox, i want another
continuous form to open. That new form "frm_BudDetail"
should only show the record which consist of same
'txtDeptBudNo'. (tbl_deptBudget and tbl_budDetail share that key)

I figured the easiest way is using a query.

SELECT tbl_DeptBudTxDetail.DeptBudNo
FROM tbl_DeptBudTxDetail
WHERE (((tbl_DeptBudTxDetail.DeptBudNo)=[forms]![frm_DeptBudget]![txtDeptBudNo]));

Problem is, it's lising every record on the table.
no filtering what so ever.

any help?

 

[wshm]

nm. stupid me.
i forgot to " the filter in vba..