Share via

Clear Combo Box after selection

Anonymous
2017-01-12T16:23:15+00:00

After a selection is made in the combo box, I need it to re-set to empty until another selection is made & IF POSSIBLE, move cursor to the first field of the form.

Here is a picture of what the combo box is doing:

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

ScottGem 68,830 Reputation points Volunteer Moderator
2017-01-12T17:32:54+00:00

Setproperty is a macro action

However, the code you have should work. Except I would not put it in a different event. You are mixing VBA and macro for the same control. Not the best idea. Neither is accepting the default name for your controls. 

If you select Setproperty where it says Add new Action, then select the Value property and set it to Null. that should work.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Anonymous
    2017-01-12T16:52:13+00:00

    Not sure how to "SetProperty"? 

    Found this after posting; added it as an event procedure in the "On Click" row & it seems to work: 

    Private Sub Combo16_Click()

    Me.Combo16.Value = Null

    End Sub

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. ScottGem 68,830 Reputation points Volunteer Moderator
    2017-01-12T16:32:38+00:00

    Use Setproperty to set the Value to Null

    Was this answer helpful?

    0 comments No comments