Mimmick in VB Code on a Form?

[jdegeorge]

Hi

I have a form that has some code that runs in the AfterInsert property. Because this code updates some hidden fields on the form as the last event before adding a record, I want to keep the user from having to tab to the next record twice.

Is there any VB code that will mimmick the [TAB] key? Thanks!

Jim DeGeorge

 

[SpankYou]

hey,

just use the setfocus property once the operation is performed...

Private Sub Your_Procedure()

Do all Your Stuff Here

Text1.setfocus

End Sub

Hope this helps

Sam

 

[jdegeorge]

I use SetFocus to get the hidden fields and the code updates that field. If you recall the keystrokes in adding a record during input, when you press the [TAB] key after entering information in the last field on the form, a new blank record is displayed.

Maybe I don't want to mimmick the [TAB] key. Maybe I want to commit this record and display a new blank record? If so, how would I do that in code?

Jim DeGeorge

 

[jdegeorge]

I decided to use [tt]SendKeys "{TAB}", False[/tt]. It worked great. Thanks for your help anyway!

Jim DeGeorge

 

[SpankYou]

Glad You got it sorted,

No probs

Sam