How to Run query based on txtbox value that is part of control source

A

Armin

Hi guys
I've created form using wizard.
Later on i created listbox where I want to show data based on my quiery

SELECT EmpEquipmentSkills.EmpNum, EquipmentTraining.Equipment,
EmpEquipmentSkills.Status
FROM EquipmentTraining INNER JOIN EmpEquipmentSkills ON EquipmentTraining.
EqNo = EmpEquipmentSkills.EqNo
WHERE (((EmpEquipmentSkills.EmpNum)=[Forms]![Employee1]![txtEmpNum]) AND (
(EmpEquipmentSkills.Status)="x"));

That is assigned to row source table/query type

And in VBA I have added Event :

Private Sub txtEmpNum_AfterUpdate()
List20.Requery
End Sub

But when I start form it prompts me for EmpNum.
How I can to refer to txtEmpNum that is part of control source.

I am new with access.

Thanx Guys
 
Top