Setting Form Focus Properly

[vbaInet]

The obvious problem is RecordID is not a field or the name of a control on your form. So change frm.RecordID to Me.RecordID

I did tell you it was aircode, which means written on the fly without testing. So it was written for you to fix little problems with field names or control names etc.

By the way prefix NoMatch with a dot.

 

[Stang70Fastback]

I had tried making that actual change, FYI, but I assumed I was wrong because when I DO change it to Me.RecordID, that's when I get an error when I try to compile it (Method or data member not found.)

EDIT: FINALLY SOLVED!!! I actually had to get rid of the prefix entirely, and make it JUST RecordID. It works now!

I apologize if I appeared lazy. I wasn't trying to give the appearance that I expect people to solve my problems for me - I had actually spent most of my day yesterday trying to get this to work, and tried all sorts of different codes, so I was just out of ideas at this point. I really appreciate your help!!!

 

[vbaInet]

EDIT: FINALLY SOLVED!!! I actually had to get rid of the prefix entirely, and make it JUST RecordID. It works now!

I would advise that you leave the "Me." reference there. Find the exact name of the textbox that the RecordID field is linked to and use that. Otherwise use Me!RecordID. The difference is dot(.) refers to the texbox whereas exclamation(!) refers to the field.

I apologized if I appeared lazy. I wasn't trying to give the appearance that I expect people to solve my problems for me - I had actually spent most of my day yesterday trying to get this to work, and tried all sorts of different codes, so I was just out of ideas at this point. I really appreciate your help!!!

It's fine. I had the impression that you felt the code just won't work. If we give advise, instead of giving up, wait until we exhaust all avenues. There are so many ways to solve this problem, I just gave you one.

Happy developing!