Hi,
using my VBA instructions I cannot update the value of the text box "Txt_Obtained" with the real time results of my combo box .
The result of this text box during the form current event is updated according to what is typed in other text boxes and depending on some option buttons of the same form, obtaining a similar result (which will be used to set the form filter)
example:
MyVar & [city] Like '" & Me.Cmbx1city.Value & "'And [code] Like '" & Me.Cmbxcode.value & "'And [enterprise] Like '" & Me.TxtEnterpriseChosen & Chr(39)
During the form_current event ,when I update text boxes or option buttons, immediately are updated MyVar and TxtEnterpriseChosen . Consequently, "Txt_Obtained" is updated, using the value already present in the two comboboxes Cmbx1city and Cmbxcode.
Here's my problem, the result of the Txt_Obtained check is correct only if I first change the value of one of the two comboboxes, and then I change that of the text boxes or option buttoms.
Instead, if first I change that of the text boxes or option buttoms and in a second moment I change the value of one of the two comboboxes, the Txt_Obtained control is not updated to the new value selected in the combobox.
I've also tried (whith no results) to insert VBA instructions into the Cmbx1city _AfterUpdate() and Cmbxcode _AfterUpdate() events.
Thank you for your clarifications