using 2 combo box to populate other field

[indhu]

Hi all,

I want 2 know, how to populate using 2 combo box to populate other field.
right now am using click event of combo to populate the other field but i want to select both combo1 and combo2 when these 2 r equal then it populate other fields.

Private Sub scene_txt_Click()
 
'combo name scene_Txt
 
myconnection
 
myquery = scene_txt.Text
 
Call rLOAD
 
 Do While storyboard!scene <> myquery
 storyboard.MoveNext
 If storyboard!scene = myquery Then
 panel_txt.Text = storyboard!shot
 sequcombo.Text = storyboard!sequencename
 action_txt.Text = storyboard!Action
 dialogue_txt.Text = storyboard!dialogue
 Picture1.Picture = LoadPicture(storyboard!Filename)
 End If
 Loop
 
 
accdb = "SELECT scene FROM shot WHERE shotid = '" & myquery & "' "
'Load SQL query into a variable
 
Set storyboard = CON.Execute(accdb, adOpenStatic)
 
end sub
 

help me

[willakawill]

when these 2 r equal then it populate other fields

This is the answer