Tab back to first field in subform

[flavioso]

Hello, Would anyone know how to tab back to the first field in a subform using VBA? I would like to prevent a user from adding more than one record in a subform, yet I want them to be able to add a new record when the record doesn't exist, and at the same time be able to update information when needed, but do not want the subform to tab to a new record.

Any suggestions?

Thanks, in advance

Bradley

 

[John Big Booty]

In the On Lost Focus event of the last tab stop on the subform you could use;

Me.NameFirstTabStop.SetFocus

 

[wiklendt]

hm. it sounds strange that you want only one record in a subform - this could indicate incorrect design. are you limiting to one record EVER, or just per user? (and why?)

 

[veraloopy]

I got around this by changing the 'Cycle' property on the 'Form' Properties to 'Current Record' instead of 'All Records'

This way, when the last tab is reached, it just cycles back through the same record instead of going to a new one.