Advice On Criteria

[Shaunk23]

Hello - Just for my knowledge.. I have built a database - occastionally when opening one of the forms it will pull random record... Close it and re-open.. it works fine.. Never saves in wrong place - just sometimes will display it.. For most of my open forms i used something like

DoCmd.OpenForm "CQrequestNotes", , , "ID=" & me.id, , acDialog


Is the correct way to do this instead

Dim TmpId as long
Tmpid=me.id
DoCmd.OpenForm "CQrequestNotes", , , "ID=" & TmpID, , acDialog

Would this make a difference at all? Any plus to assigning as variable first? This is multi user database.. Just would like some input on that! Thanks!!

 

[jdraw]

What happened when you tried it?
Tell us more about the multi user set up.

 

[Shaunk23]

It seemed to work the same. I havent had the issue today.. just a once or twice yesterday and other users have seen it... Everyone has a local FE (8 users) and a backend is on my exchange server. Connection created at open with a hidden login screen.. On unload it drops connection. Everything seems to run fine - just occasionally after a save or re query maybe one of the forms or childs pulls a different record.. seems almost like its always the last record entered i think. I just didnt know if that was the correct way to do it or not.