Filter 2nd form based on a field value of 1st form

Hi there,

I have been struggeling with filtering records on a second form. I have a
main form with 3 subforms included. On the first subform [SubFrmEquipment]
there is a combobox [CboEquipment] that gets its data from a table
[TblEquipment]. When I pres a button on that subform I would like to have
another form openend with the relevant records based on the value of
CboEquipment. The second form is also based on the table TblEquipment. The
second form has a field named TxtFailure. I would like to use the second form
as an input form for the first form.

I hope that I have explained it well enough. Any help is appreciated!

Thanks!
Yara