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
|
|||
|
|||
Multiple Drop Down
I have a combo box that displays three related pieces of
data. Grade1, Grade2 and Rate. I update the Rate field in my form with this combo box. What I would like to do is transfer the other related pieces of data in this combo box to update the two other fields in my form also called Grade1 and Grade two with the same combo box and at the same time I choose the Rate. To clarify, when I select the Rate combo box I want Rate to update, Grade1 to update and Grade2 to update all in one combo box selection. Is that possible? If so how can I do it? Thanks, Dennis |
#2
|
|||
|
|||
Multiple Drop Down
"Dennis" wrote I have a combo box that displays three related pieces of data. Grade1, Grade2 and Rate. I update the Rate field in my form with this combo box. What I would like to do is transfer the other related pieces of data in this combo box to update the two other fields in my form also called Grade1 and Grade two with the same combo box and at the same time I choose the Rate. To clarify, when I select the Rate combo box I want Rate to update, Grade1 to update and Grade2 to update all in one combo box selection. Is that possible? If so how can I do it? Hi Dennis, Sure...piece of cake. 8-) In AfterUpdate event of combobox, just assign -- combobox.Column(1) to textbox for that column (Gradex) -- combobox.Column(2) to textbox for that column (Gradey) For example, cmboRate, bound to [Rate] has controlsource like SELECT [Rate], [Grade1], [Grade2] FROM yourtable; [Rate] will be cmboRate.Column(0) [Grade1] will be cmboRate.Column(1) [Grade2] will be cmboRate.Column(2) On your form, txtGrade1 is bound to [Grade1] txtGrade2 is bound to [Grade2] So, in AfterUpdate event of cmboRate me!txtGrade1 = me!cmboRate.Column(1) me!txtGrade2 = me!cmboRate.Column(2) the column # will be determined by the order they appear in your controlsource select query, so may be different than above. Please respond back if I have misunderstood. Good luck, Gary Walter |
#3
|
|||
|
|||
Multiple Drop Down
Gary,
Thank you for your help. It works perfectly. This one fix will stop a lot of the data entry errors we have been experiencing! Ever grateful, Dennis -----Original Message----- "Dennis" wrote I have a combo box that displays three related pieces of data. Grade1, Grade2 and Rate. I update the Rate field in my form with this combo box. What I would like to do is transfer the other related pieces of data in this combo box to update the two other fields in my form also called Grade1 and Grade two with the same combo box and at the same time I choose the Rate. To clarify, when I select the Rate combo box I want Rate to update, Grade1 to update and Grade2 to update all in one combo box selection. Is that possible? If so how can I do it? Hi Dennis, Sure...piece of cake. 8-) In AfterUpdate event of combobox, just assign -- combobox.Column(1) to textbox for that column (Gradex) -- combobox.Column(2) to textbox for that column (Gradey) For example, cmboRate, bound to [Rate] has controlsource like SELECT [Rate], [Grade1], [Grade2] FROM yourtable; [Rate] will be cmboRate.Column(0) [Grade1] will be cmboRate.Column(1) [Grade2] will be cmboRate.Column(2) On your form, txtGrade1 is bound to [Grade1] txtGrade2 is bound to [Grade2] So, in AfterUpdate event of cmboRate me!txtGrade1 = me!cmboRate.Column(1) me!txtGrade2 = me!cmboRate.Column(2) the column # will be determined by the order they appear in your controlsource select query, so may be different than above. Please respond back if I have misunderstood. Good luck, Gary Walter . |
Thread Tools | |
Display Modes | |
|
|