DLookup

message from =?Utf-8?B?QXJ0aHVy?= on 3 Jun 2004
Ok, I'm suicidal.....this dlookup is doing me in. It seems so simple or should that be me?

I have a form - FrmTransactions
field - From Suburb (combo box ) text
field - From Direct Port text

I have a Qry - QryPostcodeDirect Port
field - Suburb text (this field is used for the combo box in FrmTransactions)
field - Direct Port text
example: Suburb = Kew Direct Port = Melbourne
= Manly = Sydney
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 help

Arthur
 

Archived message: DLookup (MS Access)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.