Opening forms based on criteria (1 Viewer)

[nat22]

Hello everyone,

I have a problem with opening forms.I have situation with 8 forms (small ones!) which must be open based on values in ComboBox1 and ComboBox2.
Can I do it with Select case (DoubleClick event), and how?

THANK YOU IN ADVANCE,

 

[clerics]

Do you mean that SubForm's RecordSource is Selected base on criteria of Combo1 and Combo2 .
Let try to write a Module that create a SQLstring ( strWhere )base on each case ! I think it s work !
Something like this --> Function Getstrwhere(a As ComboBox, b As ComboBox, strWhere As String)

 

[nat22]

No,
imagin situation: if the cmbOne=5e and cmbTwo=UTP open Form1,
if the cmbOne=5e and cmbTwo=FTP open Form2,
if the cmbOne=6 and cmbTwo=UTP open Form3 (I have 8 forms),

I have tried with SubForm's RecordSource Selected based on criteria of Combo1 and Combo2 but I have problems with records,

thanks

 

[clerics]

But Cuz i dont know ecxactly how your database is . It ll be great if you show more about your program !
May i know why did u use too much form ? No way to take them into one ?

 

[nat22]

The problem is in my table which is in attachment, in first column I have records 32706 and 32707 x 2 because I have 2 indentical records with difereence in column Kategorija (5e or 6) so when I update table with 2 criterias I get 2 indetical records (I mean in column Kategorija, if I choose record 32706 with criteria 5e with update the second record changes value 6 to 5e and after that I have 2 indetical record 32706 with 5e value in column kategorija)
That is why I want to open different forms with defined recordsurces in ListBoxes.