set focus after re query

S

Simon

I have the following code on a form that is based on a query, what it
does as i type in post code ( zip code) it requry every time to show
closest match

Code is


Private Sub PostCodeSearch_Change()
On Error Resume Next


Me.Requery
Me!PostCodeSearch.SetFocus
Me!PostCodeSearch.SelStart = Len(Me.PostCodeSearch)


On Error GoTo 0
End Sub


Problem is if i try to do a space it does not work


If it try to type the followin postcode po34 5gs it comes up as
po345gs how do it code it so it always spaces
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.SetFocus code to alow space 0
Set Focus on Requery Propblem 2
post code / zip code search 1
type mismatch error in macro in excel 0
No Current Record - Before Code Even Runs! 0
Code to open a query 2
Error 2185 for Text property in Header when form's recordset is em 4
Multi Selection List Box Codes Again, 2

Top