So here's the issue I having. Im using Access linked to Azure and I'm using the ID from the record to create a folder as soon as I start entering the details to save the quote that will be created, But because I am using Azure the ID field isnt populated until I save, close and reopen the record. So at the moment Im having to create the new record, save and close, then go to my list of records and open the last created record so that the ID field is populated and then continue on from there.
My thought on solving this, is to create code much like this below, but I dont know how to tell the last line to open to the last record.
DoCmd.OpenForm "QuotesF", acNormal, , , acFormAdd, acWindowNormal
DoCmd.Close acForm, "Quotesf", acSaveYes
DoCmd.OpenForm "Quotesf", acNormal, , , acFormEdit, acWindowNormal
Can somebody let me know what I need to add or if there is another way of populating the ID field without save and closing the form?
P.S I have seen some runcommands to open to the last record when opening the form but I dont want that to run every time as I want to be able to click and open specific records from a list.