auto command button (1 Viewer)

K

kitty77

Registered User.

Local time

Yesterday, 23:12

Joined

May 27, 2019

Messages

710

• Sep 13, 2019

• #1

How would I after update in a field press a command button with vba?

Basically, after the field is updated, I manually have to click the command button. Would like it to happen automatically.

Thanks...

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 20:12

Joined

Oct 29, 2018

Messages

21,449

• Sep 13, 2019

• #2

Hi. You could just "call" it. For example:


Call ButtonName_Click()


Hope it helps...

 

K

kitty77

Registered User.

Local time

Yesterday, 23:12

Joined

May 27, 2019

Messages

710

• Sep 13, 2019

• #3

Will give that a try. BTW, your website is VERY helpful. Lots of good stuff!

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 20:12

Joined

Oct 29, 2018

Messages

21,449

• Sep 13, 2019

• #4

kitty77 said:

Will give that a try. BTW, your website is VERY helpful. Lots of good stuff!

Click to expand...

Hi. Thanks! Please let us know how it goes.

 

M

Mark_

Longboard on the internet

Local time

Yesterday, 20:12

Joined

Sep 12, 2017

Messages

2,111

• Sep 13, 2019

• #5

For myself, if I have code that will be called from more than one place, I put it in its own SUB. I then reference that SUB any place I need to. This helps avoid the "Well, this button presses that button, which pushes those buttons" issues and helps you keep track of where you have code.

 

K

kitty77

Registered User.

Local time

Yesterday, 23:12

Joined

May 27, 2019

Messages

710

• Sep 13, 2019

• #6

Where can I learn about SUB's, examples, etc. I have not used them yet.

Thanks...

 

M

Mark_

Longboard on the internet

Local time

Yesterday, 20:12

Joined

Sep 12, 2017

Messages

2,111

• Sep 13, 2019

• #7

This link has a quick overview of using SUBs in VBA.