Bug in Cycle property of forms?

[glickster]

I'm having a problem with a form moving off the current record when I tab off the last field and I have the form's Cycle property set to "Current Record". It only occurs when I'm on the last record of a filtered recordset for the form. Is this a bug or a Microsoft feature? Does anyone have a suggestion?

Thanks in advance,

Geoff

 

[TheAceMan1]

How are ya glickster . . .

Indications are some form of corruption since [blue]Cycle Current Record [/blue] isn't working. Perhaps deleting and reconstructing the form will do!

For temporary relief until you find what the problem is, in the [blue]On exit[/blue] event of the last textbox in the tab order, copy paste the following ([blue]you![/blue] substitute proper names in [purple]purple[/purple]):

[blue]   Me![purple][b][i]1stTextboxnameInTabOrder[/i][/b][/purple].SetFocus[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[glickster]

Thanks AC1! I'll try it when I have the chance, for now the users can live with it (as it will be a deal of effort). They just requested a datasheet form anyways, so this might be a moot point.

Curious that the form (Cycle property) behaves as expected for other records in the filter for the form, just not the last one.