By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,760 Members | 1,202 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,760 IT Pros & Developers. It's quick & easy.

using 2 combo box to populate other field

100+
P: 140
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.


Expand|Select|Wrap|Line Numbers
  1. Private Sub scene_txt_Click()
  2.  
  3. 'combo name scene_Txt
  4.  
  5. myconnection
  6.  
  7. myquery = scene_txt.Text
  8.  
  9. Call rLOAD
  10.  
  11.  Do While storyboard!scene <> myquery
  12.  storyboard.MoveNext
  13.  If storyboard!scene = myquery Then
  14.  panel_txt.Text = storyboard!shot
  15.  sequcombo.Text = storyboard!sequencename
  16.  action_txt.Text = storyboard!Action
  17.  dialogue_txt.Text = storyboard!dialogue
  18.  Picture1.Picture = LoadPicture(storyboard!Filename)
  19.  End If
  20.  Loop
  21.  
  22.  
  23. accdb = "SELECT scene FROM shot WHERE shotid = '" & myquery & "' "
  24. 'Load SQL query into a variable
  25.  
  26. Set storyboard = CON.Execute(accdb, adOpenStatic)
  27.  
  28. end sub
  29.  
help me
Feb 7 '07 #1
Share this Question
Share on Google+
1 Reply


100+
P: 1,646
when these 2 r equal then it populate other fields
This is the answer
Feb 7 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.