I saw your post and I thought I might be able to help! Make sure that:
1. The "Record Source" property for the Form is set to the "QRYNewBookingV2" (which you said it was)
2. Make sure that each control on the form has it's "Control Source" property set to the name of the corresponding table field. (Your post didn't mention this, so make sure these controls are set correctly)
Which you probably already know...but just to be super clear, once those 2 things are in place, the Access form should automatically populate the controls with whatever record you have selected. So, once you move to that record, the controls should be populated automatically. Then calling the "Me.UserID.SetFocus" should work correctly.
So, to answer each of your questions:
1. "Is my syntax referring to the table correct?"
Hmm...I may see a problem: At one point in the post, you refer to the table as "TBLLaptop", but here: "Table!Laptop!EncryptionStatus" you just use "Laptop"...so not sure if that is a typo, but it could be a code error. But really, you shouldn't have to set this manually to do what you want to accomplish (if I understand you correctly). See my note #2 above and the next point below, which is much more important...
2. "Should I be referring to the query and if so what is the syntax? Query!QRYNewBookingV2!EncryptionStatus?" Yes...this is most likely your problem. But again, you shouldn't have to manually set these fields (if I understand you correctly). Were you unable to get this to work this way?
Anyway, I hope this all makes sense! Does this help at all, or am I telling you things that you already know? Anyway, if you still have more questions, please let me know and I'll do what I can to help!
Geoffrey L. Griffith
Wrox Author of:
Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference