prevent navigate to the next record

[pushkar1986]

I have created form .I generally use tab button to go to next test field .When I am at the last text field & i press tab button, it goes to next record.how to prevent this? I don't want it to go to next record like that..becomes very confusing....heh...

thank you in advance

waiting for reply
​

 

[John Big Booty]

You could put something like the following in the OnLostFocus event of your last control;

Me.NameFirstControl.Setfocus

 

[pushkar1986]

You could put something like the following in the OnLostFocus event of your last control;

Me.NameFirstControl.Setfocus

thanx....i will try that

 

[khawar]

Instead of using the code just go to form properties and set its "Cycle" property to current record.

 

[pushkar1986]

Instead of using the code just go to form properties and set its "Cycle" property to current record.

where is that??& how to do that???

 

[khawar]

Open the form properties while you are in design view and there you can find this property

 

[missinglinq]

Open the form in Design View then goto Properties - Other and change it to Current Record. I've never been able to figure out why Current Record isn't the Default for this Property.