none
NewRecord Macro Not Running in Access Web App RRS feed

  • Question

  • I have created a very simple, single-table, Access 2013 Web App to be used for data entry.  I selected the action for the On Start Macro as "NewRecord" in the hopes that, anytime someone opens or refreshes the app, an empty record will appear for them to fill out the fields.  I am assuming List View is the default since it appears as the first tab, DataSheet View is next (I can't find a way to verify the default view, though).  NewRecord will not, for the life of me, run when the app launches and/or refreshes.  To test the connection, I also added a Message Box to run On Start...the Message Box appears, but NewRecord does not run.  My database connection allows read/write and can connect from any location.  No idea what I'm missing so any assistance would be much appreciated!
    • Edited by djcgardner Wednesday, November 11, 2015 10:11 PM
    Wednesday, November 11, 2015 9:53 PM

Answers

  • Hi djcgardner,

    >> To test the connection, I also added a Message Box to run On Start...the Message Box appears, but NewRecord does not run

    I could reproduce your issue. In my option, NewRecord action is equivalent to use the Add button in the action bar to add a record. In other words, NewRecord is according a View like List View.

    For your requirement, I suggest you add the NewRecord method in On Load of the specific view which you want end user fill out the fields.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Thursday, November 12, 2015 5:11 AM