form showing entry

[extreme]

I have got a db when I enter a new client in the client form it saves it in the table but when I return to the form the client I have just entered is still there so I cant enter a new client it does'nt clear the text in the text box can anyone help

Thanks

 

[Uncle Gizmo]

You need to open a form with the "data entry mode" you can do this in code from a command button like this:

    Dim strDocName As String

    strDocName = "frmYourFormNameHere"
    DoCmd.OpenForm strDocName, , , , acFormAdd

 

[extreme]

You need to open a form with the "data entry mode" you can do this in code from a command button like this:

    Dim strDocName As String

    strDocName = "frmYourFormNameHere"
    DoCmd.OpenForm strDocName, , , , acFormAdd

Thanks works perfect