Display Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew C - 11 Jul 2007 12:00 GMT

Hi

In my client table i have a field called suburb. This field looks up the
suburb table to get its values. In the Suburb table i have a suburb field
and Post code fields.

I have based a form on a clients query, and it shows the suburb and all
information as needed. What i need to show is a postcode on the form. How
can i get it to lookup up the suburb in its own table and return the postcode
relating to that area.

If i add the suburb table to the query and add the postcode field to the
query, it stops me from updating any records. The postcode is purely for
display view only.

Thanks for your help

Reply to this Message

Chris Reveille - 11 Jul 2007 13:22 GMT

Have you tried using dlookup

Signature

Chris

> Hi
>
[quoted text clipped - 12 lines]
>
> Thanks for your help

Reply to this Message

Ofer Cohen - 11 Jul 2007 15:46 GMT

With the use of DlookUp

In the ControlSource of the text box where you want to display the postcode
you can write

=Dlookup("[postcode]","[suburb],"[suburbFieldNameInTheTable]=" &
[suburbTextBoxNameIntheform] )

If the suburb is a text field type, then you need to add single quote to the
value
=Dlookup("[postcode]","[suburb],"[suburbFieldNameInTheTable]='" &
[suburbTextBoxNameIntheform] & "'" )

Note: make sure the fields and table name are correct

Signature

Good Luck
BS"D

> Hi
>
[quoted text clipped - 12 lines]
>
> Thanks for your help

Reply to this Message

Andrew C - 16 Jul 2007 03:26 GMT

Just got around to Doing it and Works great

Thanks alot

Andrew

Reply to this Message