Clear Form issue.

[penfold1992]

i have a form that adds some value into the database once a button is pressed. The value comes from a field that I want to clear after the value has been inserted. I have no idea what is wrong with the code but it doesnt clear the box.

heres the two pieces of code I am using...

Private Function Clearbox()
NewSupplier = Null
End Function

thats the function and then here is the button

Debug.Print "Successful Insertion"
SupplierList.Requery
Forms![Request Form]![cmbSenderReciever].Requery
Clearbox

i get the "Successful Insertion message in the "Immediate" window so I know the code gets down that far.

 

[llkhoutx]

You're not using clearbox as a function, but as a subroutine.

 

[penfold1992]

what do you mean?