VBA and Grid Fields

(0) Share

Report

Posted on by U079310

405

Using vba to modify PO Transaction entry screen. Wish to run some code when the user changes the Item Number field on this screen. Right now the code runs fine but not until the user completes the entire grid line and either tabs or clicks off the line. Is their a method to run this code when the user tabs off the Item Number field instead of waiting until they leave the grid line ?

Rick

*This post is locked for comments

All responses (5)

Answers (0)

L Vail 65,271 on at

Like (0)

Report

Re: Re: Re: Re: Re: VBA and Grid Fields

Great!

I will be working in the Hands On Lab during Convergence. Stop by and check it out! I will be the one wearing a poncho - I might even be wearing a hat :)

Kind regards,

Leslie
U079310 405 on at

Like (0)

Report

Re: Re: Re: Re: VBA and Grid Fields

Hey you do ok. I got started with this stuff by taking a VBA class from you about 5 years ago in Chicago. See you in Atlanta.

Rick
L Vail 65,271 on at

Like (0)

Report

Re: Re: Re: VBA and Grid Fields

Rick,

Every now and then I get lucky.

I'm glad I could help :)

Leslie
U079310 405 on at

Like (0)

Report

Re: Re: VBA and Grid Fields

God I feel like such a dork, yes of course thats the way to do it. Am very familiar with that coding but for some reason did not think I had access to the field itself since it was in a grid. Tks for pointing out the obvious. lol

Rick
L Vail 65,271 on at

Like (0)

Report

Re: VBA and Grid Fields

Have you attached your code to a grid event or a field event? It sounds like you may have attached your code to a grid event.