SetFocus to a Subform field

[Micron]

As I attempt to apprise everyone with my signature, doesn't work doesn't help. Neither does "I tried, but..."

It takes as little as a missing or misplaced character to cause a problem. The error number suggests you haven't drilled down to the proper level before attempting to apply something to it. The code itself is insufficient; we have to understand what the names apply to.

[dhicks]

I've attached a zipped copy of my db. Hope this is an easy one to catch. Thanks to everyone for your help!

[aytee111]

Set the prior fields Tab Stop to No.

[Bulzie]

Another tip to get the right syntax for a field, have your main form in design mode, go into a query(new one or saved one) and on criteria line in a column, right click and select Build, double click Forms, Loaded forms, select your main form, then the subform and find the field in the box and double click it. This will give you the syntax that should be correct and you can add the .SetFocus on the end. Copy that syntax and use it in your code.

[dhicks]

It works!!! The last 2 responses did the trick. I'm going to be making great use of the Build feature from now on. You guys are the best, thank you very much! I've learned a lot from this project. Now I have to think of a new monster to build!!

[Bulzie]

Awesome, great job figuring it out!!!