MS Access - Run VBA script to OnClick event

Question

I am trying to get a VBA script to run when I click a button on a form in access. I've looked at guides online and they say to press [Event Procedure] on the drop down but I don't seem to have the option to do that. Any ideas?

edit:

Clicking on the three dots just takes me to a screen to enter a macro, I don't get the option to choose.

Thanks!

No options shown on drop down for OnClick

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

Clear the On Click field (delete the [Embedded Macro] text)
After that, click the ... button.
You should see this dialog box :
Choose Code Builder.

Enjoy :D

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jul 23, 2014 at 10:50

parakmiakos

3,0209 gold badges31 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

aforward Over a year ago

Hi Parakmiakos, Thanks for the answer, if I do that rather than getting the above box I get taken to a screen for a Macro. There is no option for VB, can't figure out why! Do I have to enable VB somewhere or something?

parakmiakos Over a year ago

Do the first step, press the delete button on your keyboard, while focusing the On Click field.

Collectives™ on Stack Overflow

MS Access - Run VBA script to OnClick event

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related