Drop down and Filtering

G

George

Dear gurus,

I have a tabbed form. On the first tab I use data from my main table
(T_JobsInput) and on the second one data from the many table
(T_JobsEquipment). The relationships and the recording are all OK, but I
face the following problem:

The equipment (unit field) on the second Tab uses a drop down menu which
select values from a third table (T_Equipment). On that third table I have
created a field i.e. TypeOfJob. The drop down menu on the second tab uses a
filter in order to filter only those records having the same
TypeOfJob(TypeOfJob is a field in the first tab), but the filter doesnt work
properly. What mistake I have done? The SQL shown below:

SELECT T_Equipment.UNIT, T_Equipment.MODEL, T_Equipment.LICENCE,
T_Equipment.TypeofJob
FROM T_Equipment
WHERE (((T_Equipment.TypeofJob)=[Forms]![F_JobInputTABS]![TypeOfJob]))
ORDER BY T_Equipment.UNIT;

Any ideas please?

Thanks in advance
 
Top