MOVE TO FIRST FIELD IN NEW RECORD

[Kay]

Continuous Subform with a calculated text box in the subform footer. When
ever I tab through the last field it takes two "tabs" to get to the next
record. I have tried running a macro on the last field using the "onexit"
event to set focus on the first control in the new record. I have verified
that the tab order is correct and the first control tab number is "0" I dont
know what else to do...

 

[Klatuu]

When you tab out of the last control on the subform (the first of the two
tabs), where does the focus go?
What is the Cycle property of the subform?

 

[Kay]

The cycle is set to all records and originally it was focusing on the record
selector of the new record when I hit enter. I changed the record selector
property to no and now I haven't a clue where it is focusing. I even put a
msgbox macro on every control in the form ongotfocus event so i could try and
figure it out because I couldn't see where the curser went. Message box
never popped up it was very strange.

 

[Kay]

I guess I should tell you when I ran the Macro to reset the focus on the
first control, it told me that that control did not exist in that record.

 

[Kay]

Ok. Had my form set to split form so that my main form would appear in
datasheet view (since it cannot be opened in datasheet view from the built in
switchboard) then added a subform so that it would appear as a subdatasheet.
Then moved the splitter bar all the way over and set the subform visible
property to "no"....

so.... you can not run a gotocontrol macro on a hidden form.

 

[Klatuu]

That would be correct. A control with the Visible property set to No cannot
receive the focus.