Using DLookUp to populate a form field

[Thurls]

Hello all,

I'm new to this site so be kind, I use a form to poulate a table in Access 2000, in the form there is a field to input suburb then another to enter the post code for that suburb. I have a another table with all the suburbs and their post codes so I thought I could use DLookUp to populate the post code field.

I'm using a VB code on enter, like this

Private Sub Postcode_Enter()
Dim varX As Variant
varX = DLookup("[Pcode]", "T_Postcodes", "[Suburb1] = '" & Me![Suburb] & "'&quot
End Sub

but get a nothing in the postcode field, not getting an error message just no result. any ideas?

Cheers,

Cole

 

[scriverb]

Your idea is a good one. You are just not executing this code at all. Put the following code in the forms OnCurrent event procedure and the AfterUpdate event procedure of the [Suburb] control.

Me![Post_Code] = DLookup("[Pcode]", "T_Postcodes", "[Suburb1] = '" & Me![Suburb] & "'&quot

This way everytime you move to a new record or someone updates the [suburb] control the DLookup will populate the control Me![Post_Code]. Change this control to the name of your forms control.


Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[Thurls]

Thanks for your help, much appreciated, It works great.
I have lots to learn.

Cheers,

Cole

 

[scriverb]

Great!!

Glad to be of help. As for having a lot to learn, we have all been there. One step at a time and pretty soon you will be answering questions here.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???