Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Access 2013 Macro to jump to first Blank textbox on form

  • 04-11-2014 03:29PM
    #1
    IrishIrish
    Registered Users, Registered Users 2 Posts: 1,000 ✭✭✭


    Hi there,

    I have a database where I am constantly putting in customer payments and the date of payment. Each customer could have 50 or 60 payments and its a bit of a pain having to scroll down to the bottom in order to add the next payment.

    I have a form with 60 boxes called Payment 1, Payment 2 etc etc where I enter the date and then another box beside them where I enter the Payment Amount. Is there a way I can have a button at the top of the page that I can press and it will automatically find the first blank 'Payment Date' box and place my cursor there?

    Thanks.


Comments

  • #2
    FSL
    Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭FSL


    Who designed it? It's not exactly user friendly.


  • #3
    IrishIrish
    Registered Users, Registered Users 2 Posts: 1,000 ✭✭✭IrishIrish


    Yeh was just a template that was downloaded which did the job nice and quickly. I know it would be easy enough to do if all the payments were in the same column. Just trying to see if there's a way of doing it now in the current setup.


Advertisement