Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 65
  • Last Modified:

How to trigger the next record button on an access form via vba?

I’m trying to call the below macro from another module and it does work, but it’s a hit or miss.  Is there a better way to do it?

Public Sub btnNextRecord_Click()
    DoEvents
    DoCmd.GoToRecord , , acNext
End Sub

Open in new window


Just in case it matters, here is how I’m calling it.
Call Forms("frmMyTicketAudits").btnNextRecord_Click

Open in new window

0
kbay808
Asked:
kbay808
  • 5
  • 5
1 Solution
 
PatHartmanCommented:
If you want to make common code, put it into a standard module.  Forms are classes and they are not available unless the form is open.
0
 
kbay808Author Commented:
I will always have the form open and I'm calling it from a standard module.
0
 
PatHartmanCommented:
It only makes sense to call it from a form.  in a standard module, you don't have a bound recordset which is what this code affects.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
kbay808Author Commented:
The reason why I'm calling it from a standard module is because I am calling it from Excel.
0
 
PatHartmanCommented:
Can you tell us what you are trying to do with this code and why you are running it in Excel.  If you are attempting to process a recordset, this is the wrong approach.  You would simply open a recordset using ADO and process that in EXCEL without automating Access.
0
 
kbay808Author Commented:
I have an excel file that compiles and processes that data.  I have code that updates all of the fields in an access form from excel that works great.  The only thing that I can’t do consistently is click the next record.  My goal is to be able have the user not have to go back and forth between excel and access.  The access form will always be open during this process.
0
 
PatHartmanCommented:
Let's start with - form's don't store data.  Tables store data.  That means that your Excel app, if you are using it to update data (and I'm having trouble with that also but that's a different issue), should be updating a table NOT trying to poke data into an open form.  

If you want to use Excel to update data in an Access table, do it by opening a recordset in Excel and updating that way or by running an update query.  Do not do this by manipulating forms.   If you are doing this because you have code in the form's BeforeUpdate event that needs to run, why not just do the data entry in Access and eliminate Excel from the process?  You can export the data back to Excel when you are done.
0
 
kbay808Author Commented:
You way make more sense.  I will work on doing it that way.
0
 
kbay808Author Commented:
Thanks for your help
0
 
PatHartmanCommented:
Glad to help.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now