VBA to click a button - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

VBA to click a button

Thomas Corbett

3 years ago

I am trying to have a button on one form called Manager Review open another form called service list and depress a button on that form called show all. Here is my code which I am pretty sure is correct since it not that hard.

        DoCmd.OpenForm "ServicelistF"
        Forms!servicelistf!StatusCombo = 2 'Serviced
        Forms!servicelistf.UnassignedServiceCalls_Click

This is from the Security Seminar

I am getting the following error

Runtime Error - 2465
Application-defined or object-defined error

I am running Access 2016 not sure if that would affect this code though

Thanks

Tom -

	Kevin Robertson @Reply 3 years ago
The click event for the Button is Private (UnassignedServiceCalls_Click). If you make it Public the code should work however, I would recommend creating a Public Sub Routine that can be called from both places.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View