Jumat, 26 April 2013

[MS_AccessPros] Auto fill control through button click

 

Hello all,

Am trying to auto fill my DDate control through a button click.

The code behind the button is below.

Can some correct my code please.. the control i wanted to fill is on the subform as indicated with the first line of code.

Please bear with me, am trying to learn how to code..

Thank you,
zjubias

Private Sub cmdAddDetail_Click()
On Error GoTo Err_cmdAddDetail_Click

Me.sbfDocdetail.SetFocus
DoCmd.GoToRecord , , acNewRec
Me.DDate = Date


Exit_cmdAddDetail_Click:
Exit Sub

Err_cmdAddDetail_Click:
MsgBox Err.Description
Resume Exit_cmdAddDetail_Click

End Sub

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic ()
Recent Activity:
MARKETPLACE


.

__,_._,___

Tidak ada komentar:

Posting Komentar