delete button help

[gheepok]

i want to create a button that act as pressing the DEL key. Can someone want help i. thanks

 

[pbaldy]

To delete a record? Have you tried the button wizard?

 

[gheepok]

yes. i have try that. the delete button wizard will delete every data in the current form.
i want a button that can delete a seleted field only.
please help.

 

[pbaldy]

Me.TextboxName = Null

or

Me.TextboxName = ""

 

[ghudson]

yes. i have try that. the delete button wizard will delete every data in the current form.
i want a button that can delete a seleted field only. please help.

Then you want to delete the value of the field that had the focus before you clicked your delete [Clear] button. This should do it...

Application.Screen.PreviousControl = ""

 

[gheepok]

thanks ghudson.
Application.Screen.PreviousControl = "" works.
this works on a main form only.
but how to do this in a main form button that clear a field in a subform.
please help.