473,549 Members | 2,726 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

using 2 combo box to populate other field

140 New Member
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
1 1587
willakawill
1,646 Top Contributor
when these 2 r equal then it populate other fields
This is the answer
Feb 7 '07 #2

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

Similar topics

1
2538
by: martim07 | last post by:
How do I have a textbox on a subform automatically fill in with a value after I select an item from a combo box on a form (e.g., select a product name in a combo box and have the subform populate based on THAT EXACT product name)? I want the entire subform to populate based on the selection from the combo box. Do I have to bind every...
5
2449
by: Filips Benoit | last post by:
Dear all, How can i populate a combo with the field-caption-names of 1 table? Thanks Filip
4
3099
by: bill.brennum | last post by:
Hi, This is probably a question with a simple answer, but here goes. I have a form linked to a table. There is a field on that table that while not showing on the form, I would like to populate via a lookup using either a popup or subform. This is an employee name match application that will allow a user to lookup a corporate employee...
2
2898
by: Dave McKie | last post by:
Hi all I am trying to Populate a combo box from a selection in an adjacent Listview. The Listview lists as a string the field names of 4 different fields in tblFile. So far I can populate the combo box with the correct number of records(only 4 in the test database) but the data is the actual string being passed which is actually the right...
1
6089
by: sara | last post by:
I am learning how to use simple functions to make my apps more powerful and efficient. On one screen, I want to populate field B: ItemDescription by looking up the ItemDescription in the Items Table. I would use the key to the Items Table from the selection the user made in the combo box. SO: User chooses an item from the combo box...
16
10476
by: agrawal.solutions | last post by:
Hello Friends I am asking a very silly question but i dont find any solution fo this.. I am selectiong a recordset and want to populate a combobox where id would be inviseble and the content would. I am getting the recordset and the no of record but then i am unble to populate the combobox. I have already tried all the function starting...
7
9818
by: Harris | last post by:
Dear all, I have the following codes: ====== public enum Enum_Value { Value0 = 0, Value1 = 10,
2
3660
by: pankajm | last post by:
Hello Friends: I am trying to populate a subform that has three fields that would pull view only data from a child table. The criteria for this data is to select the three fields where one of them is the value of column 1 of a combo box on the main form. This field is also the master child link between the two tables. The combo field is SSN....
6
1764
by: dougmeece | last post by:
Hello, I have a form that I would like to auto-populate text boxes in based on the selection made from a combo box. I have set the form record source to a table "SubmittedTo" which contains 3 fields (4 including the ID). The fields are Name, Website and Type. I want to select the Name from a combo box and have the website and type text boxes...
0
7451
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7720
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7960
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7475
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7812
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5372
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3501
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3483
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1061
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.