You can use a UNION query.
Thanks for the reply. But in the due course I had added a line cmb_PID_Inst_Type= " " (highlighted in Red) which is actually what I was looking for.
But the sub form is not getting populated with the relevant data. (Subform query snap attached)
The requirement is based on selection in
Ref_Type all records matching the criteria shall be appearing on the subform and further upon selection of
PID_Inst_Type only records matching with Ref_Type and PID_Inst_Type shall be displayed .. like wise Installation_Type shall show all records in Subform based on selection on Ref_Type, PID_Inst_Type and Installation_Type.
The following is the code I had used. Any suggestion or observations on the below is appreciated.
Private Sub Form_Load()
Cmb_Enquiry_No.RowSourceType = "Table/Query"
Cmb_Enquiry_No.RowSource = "Select Distinct Enquiry_No from T_master_pid"
Cmb_Ref_No.RowSourceType = "Table/Query"
Cmb_Ref_No.RowSource = "Select Distinct Ref_No from T_master_pid"
Cmb_Ref_Type.RowSourceType = "Table/Query"
Cmb_Ref_Type.RowSource = "Select Distinct Ref_Type from T_master_pid"
Cmb_PID_Inst_Type.RowSourceType = "Table/Query"
Cmb_PID_Inst_Type = " "
Cmb_PID_Inst_Type.RowSource = "Select Distinct PID_Inst_Type from T_master_pid"
Cmb_Installation_Type.RowSourceType = "Table/Query"
Cmb_Installation_Type.RowSource = "Select Distinct Installation_Type from T_master_pid"
End Sub
