I want to tab to a new record in a subform.

[Darth21]

I'm am new to this forum. I have created a trouble log for our company, which logs calls related to the park such as a ride thats broken or a sink that is stopped up. In the subform it tabs in the order that i want it to go, but it doesn't go to next record, it just starts over at the top. Do i need to create a Macro to get to tab to next record.

Do anyone have any suggestions?

[Missinglinq]

...In the subform it tabs in the order that i want it to go, but it doesn't go to next record, it just starts over at the top...

Are you saying that it tabs through the Controls on a given Record, then starts back over at the top of that same Record? Or starts over at the top of the Subform, i.e. on the first Record on the Subform?

Linq ;0)>

[Darth21]

It starts back over at the top of the subform in the same record.

Thanks, Brian

[Darth21]

It starts back over at the top of the subform in the same record.

Thanks, Brian

[Missinglinq]

In Form Design View, if you go to Properties - Other, is the Cycle Property set to Current Record? If so, change it to All Records and see what happens.

Also, can you use your mouse and actually add a New Record?

Linq ;0)>

[Darth21]

Yes, That worked!! Thanks a bunch, you were a great BIG Help!!


Thanks, Linq

[Missinglinq]

Glad we could help!

Linq ;0)>