Being able to view the record number from SQL table

[Dpot]

I have a database that I'm trying to play with the idea of having it located in a folder on a network drive and just putting a shortcut to it on other peoples desktops. This will make it easier for me when I do updates so I don't have to update everyone's computer. We're using the database for record entry, and often times they need the record number of the entry they're making. We have a text box called "Record #" on the forms they use where the ID shows. It works fine on a stand alone database. As soon as we switch it over to SQL it doesn't show. Show I put a button with code that refreshes the record and it will show the record number. The problem we're having is this; Now that we're playing with the idea of putting the database in a network folder we've been noticing that if more than one person is using the database, it won't give the user a record number at all, it'll flash wicked quickly upon entering but that's about it. Any thoughts? Would there possibly be a user setting I'm missing in the database options? Any help is appreciated.

[Seth Schrock]

Instead of refreshing the record, try just saving it. Usually that works. The code would be DoCmd.RunCommand acCmdSaveRecord.

[Dpot]

Thank you! I was using

With DoCmd
.Save
.RefreshRecord
End With

Guessing it's the refresh that was holding it up. Thanks so much!