Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

After Update on ComboBox when setting value

Status
Not open for further replies.

MDJ52

MIS
Mar 30, 2001
120
US
I have tried to research this in the forums to no avail, so I decided to just post a new question.
I have a set of 3 combo boxes on a form. Each has a 'after update' function that updates a number of text boxes on the form. I wish to also use the form for lookup where the combo boxes get populated by values that are stored in a history table for the data that came from this form.
My problem is that when I set the values in the combo boxes I would still like them to go ahead and run the code behind the 'after update' condition. If I go in and click the drop down and reproduce what I just set the value in the combo box to, the 'after update' code executes.
Is there a way to execute the 'after update' code with programatically setting the value into the combo boxes?
 
How about factoring out the code you are talking about into a separate SubRoutine and then call it from the AfterUpdate event of the ComboBoxes. You could then also call these SubRoutines from the Current event of the form which I believe will give you the results you are looking for.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top