Reputation: 435
I have a macro for onclick event for a combo, how do i have something to clear the text box in the same form when the user click on combo box and make selection. I would like to do the clear inside the same macro rather than a procedure.
Upvotes: 2
Views: 16289
Reputation: 49009
Not clear what you mean by macro? Do you mean the new macro language in Access, or do you mean VBA code?
In VBA code you can just go:
Me.MyComboBox = null
In macro code, you use SetProperty, input the name of your Control, set the Property to "Value" and just leave the Value blank.
Upvotes: 5