DLookup

A

Arthur

Ok, I'm suicidal.....this dlookup is doing me in. It seems so simple or should that be me

I have a form - FrmTransaction
field - From Suburb (combo box ) tex
field - From Direct Port tex

I have a Qry - QryPostcodeDirect Por
field - Suburb text (this field is used for the combo box in FrmTransactions
field - Direct Port tex
example: Suburb = Kew Direct Port = Melbourn
= Manly = Sydne
What I 've been trying to do is when the user selects a suburb in FrmTransactions, the Direct Port field automatically populates

I've tried 100's of ways and looked up inthis forum , but still can't get it right

Please hel

Arthur
 
Top