If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update second combo box when first combo box is selcted
Hi,
New user here and hopefully an easy answer. I have 2 fields on a page, field one is violationcode and field 2 is violation. Both fields pull from a table. I would like for violtaion to be auto populated with the proper info when something is chosen from violationcode and vice versa. Could someone please tell me how this happens? |
#2
|
|||
|
|||
Update second combo box when first combo box is selcted
"Lawrence" wrote in message news Hi, New user here and hopefully an easy answer. I have 2 fields on a page, field one is violationcode and field 2 is violation. Both fields pull from a table. I would like for violtaion to be auto populated with the proper info when something is chosen from violationcode and vice versa. Could someone please tell me how this happens? If both violationcode and violation are in the same table, include them both in the Row Source of the Combo Boxes, sizing each so that only the one of interest is visible. In the AfterUpdate event of each Combo Box, set the value of the other ComboBox using the .Column property of the Combo Box. Larry Linson Microsoft Access MVP |
#3
|
|||
|
|||
Update second combo box when first combo box is selcted
Sounds like if given a ViolationCode I then know the Violation (1:1).
If this is true you only need to store the ViolationID and can convert that into a violation as needed (reports, forms, etc.) Ed Warren. "Lawrence" wrote in message news Hi, New user here and hopefully an easy answer. I have 2 fields on a page, field one is violationcode and field 2 is violation. Both fields pull from a table. I would like for violtaion to be auto populated with the proper info when something is chosen from violationcode and vice versa. Could someone please tell me how this happens? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I need update query to run from combo box | Bill_De | Running & Setting Up Queries | 15 | August 12th, 2005 04:53 AM |
Disable text box via combo box | StuJol | Using Forms | 1 | August 10th, 2005 09:29 AM |
Office XP Update Problem | Bill | General Discussions | 0 | December 1st, 2004 06:11 PM |
Update combo box | Phil | Using Forms | 3 | August 27th, 2004 08:47 PM |
Command button to update choices in a combo box | accessbabe | General Discussion | 1 | August 6th, 2004 06:03 AM |