Zipcode Autofill. Need to verify only first 5 numbers????

[Shadez]

Me!FCity = DLookup("City", "lkpZipCodes", "ZipCode = " & "'" & Me!FZipCode & "'&quot

That is currently what I have to lookup the field. I only require the first 5 numbers to be check though.

I know there is a way that would accomplish this. Stripping everything at the first 5 characters. It is a text field.

I have tried a few diffrent possibilities with no luck. if pissbile could you show in the above line how to accomplish this?

Me!FZipCode

is the result I need stripped down to the first 5 characters for comparison.

 

[Databaseguy]

Me!FCity = DLookup("City", "lkpZipCodes", "ZipCode = " & "'" & left(Me!FZipCode & "'",5))

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[Shadez]

first off thanks for the quick response. I cut and pasted that code directly replacing mine. I ended up with and error though

Run Time Error 3075

Syntx Error In String IN Query Expression 'ZipCode = '01852'

any idea on whats happening here?

 

[Databaseguy]

No prob. class is boring today....

Maybe get rid of the apostrophes ??? ("'&quot

Me!FCity = DLookup("City", "lkpZipCodes", "ZipCode = " & left(Me!FZipCode & ,5))
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[Shadez]

Still no go on that. Seems that the "'" is required due to this being a TEXT field.

 

[Maquis]

Try this:

Const dQuote = """" 'sets dquote equal to a double quote

Me!FCity = DLookup("City", "lkpZipCodes", "ZipCode = " & dQuote & left(Me!FZipCode,5) & dQuote)


Good Luck
Maq B-)
<insert witty signature here>

 

[Shadez]

Databaseguy and Maquis. Thanks for all the assistance on this. Maquis your last suggestion completed the code. Now it works just fine. Thanks once again to both of you.