Solved VBA sendkeys BACKSPACE (1 Viewer)

[skdn71]

Please help me if I run the VBA below with form_load on the Listproduct form it works fine but if I run it from frmNav on Load_form Listproduct form it doesn't work

Private Sub Form_Load()
    ' Select the text in the textbox
    Me.txtSearch.SetFocus
    Me.txtSearch.SelStart = 0
    Me.txtSearch.SelLength = Len(Me.txtSearch.Text)
    
    ' Simulate a backspace key press
    SendKeys "{BACKSPACE}"
End Sub

 

[GPGeorge]

Please define the term, "doesn't work".

What do you expect to happen?

What actually happens instead?

 

[skdn71]

SendKeys "{BACKSPACE}" on txtSearch

When Listproduct form open frm frmNav

 

[skdn71]

see photo

 

[Gasman]

Why not just use

Me.txtSearch = ""
or
Me.txtSearch = Null

 

[Pat Hartman]

I'm not sure the purpose of the code. You should NEVER dirty a record in the load event and if this is an unbound control, it will always be null when the form opens so you would never have to clear it.