Hello all, this is my first post and hope to get a solution to my inquiry. I have a form where I enter a vendor ID and the form auto populates all vendor information i.e. name address, zip code etc. When the zip code portion populates I have a table with just zip codes and cities and states and would like the city state to be looked up on this table. I have been told the dlookup would work but with the code, I am getting the runtime 3075 error. Exactly as below:
Run-time error '3075':
Syntax error (missing operator) in query expression '[Zipcode]='.
I have included the code string I am using on after update event below:
Please, any insight would be appreciated. I am not going to get into how this is for a company where I promised a deliverable, but it is...
Thank you in advance -
Ken
Run-time error '3075':
Syntax error (missing operator) in query expression '[Zipcode]='.
I have included the code string I am using on after update event below:
Code:
Private Sub PSTCD_Change()
Me.txtcty = DLookup("[City]", "tbl_zips", "[Zipcode] = " & Me.PSTCD)
Me.txtst = DLookup("[State]", "tbl_zips", "[ZipCode] = " & Me.PSTCD)
End Sub
Please, any insight would be appreciated. I am not going to get into how this is for a company where I promised a deliverable, but it is...

Thank you in advance -
Ken