current record control

[jaanisf]

How can I get a current record showed in a textbox?

I know, it's kinda simple: txtbox1 = Me.CurrentRecord

But, where should I put the code, so that it would update on every buttons press, on every TAB press etc?

 

[dcx693]

Put it into the On Current event of the form.

 

[jaanisf]

Tnx, it works
Can you tell me another one:

DoCmd.GoToRecord , , acNewRec
DoCmd.GoToControl Me.txtcontrol1

Here, I want that on button btnNewRec click the control txtcontrol1 to be active, but this code gives me an error. What is wrong here?

 

[jaanisf]

Never mind, I managed it )