Home > OS >  click button VBA to update a drop down field to a specific value
click button VBA to update a drop down field to a specific value

Time:11-06

I'm wanting a button to perform multiple actions. when clicked it should: add 1 to dial attempts field change the "leagGenOutcome" to "no answer"

the problem is that the "leadGenOutcome" is a dropdown field taking it's options from another table.

I used this VBA code which works for a field with no drop down, but doesn't work on the drop down field.

Private Sub AddDialAttBTN_Click()

    DialAttempts = DialAttempts   1
    
    LeadGenOutcome = "no answer"
    
End Sub

I know I must be missing something simple to get this to work. any help is much appreciated. EDIT by "doesn't work" the DialAttempts counter ticks up as it should but a "run time error" displays stating "the value you entered isnt valid for this field" LimitToList property is Yes "no answer" is a listed item the field that LeadGenOutcome is bound to is called LeadGenOutcome01 in a form called LeadGenOutcomes.

currently it's a test database which I am using to learn how best to arrange and format.

CodePudding user response:

changed "no answer" to "2" which is the ID for that response in the linked form. I had thought that it would display as "2" and not the associated text. this is not the case. thank you June7 for the assist.

  • Related