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!

Answer 1

1. Clear the On Click field (delete the [Embedded Macro] text)

2. After that, click the ... button.

3. You should see this dialog box :

4. Choose Code Builder.

Enjoy :D