Mailing Label Report - wrong value selected

[Davidekreed]

Hi,

I have Post Code Table which lists
ID, Post Code, Suburb, State etc.

In a form, I use a combo box for suburb which then automatically returns the related values for post code, state etc in the form and back in the table.

My problem is, when I do a mailing label and pick up the 'Suburb' field from the table, the report shows the Suburb ID number instead of the Suburb name.

Any help to fix this would be much appreciated.

P.S...A simple contact report using name, address, suburb, state etc actually returns the right value for suburb....not the suburb id...
Therefore it only seems to happen in the label wizard....Strange???

[This message has been edited by Davidekreed (edited 10-17-2001).]

 

[SteveA]

Have a look at the recordsource for the report that works and for the report that isn't.

It sounds like the recordsource to your labels report needs to have the Postcodes table added and linked using the SuburbID. Instead of displaying the SuburbID field on the report, change the source to the Suburb field from the Postcodes table.

I hope this helps

SteveA

 

[Davidekreed]

Thanks Steve, but no matter whay I do it still returns the value of the SuburbID and not the Suburb name.

PLEASE PLEASE I need your help!

The problem seems to occur only in the Label Wizard.

Please reply, many thanks,
Dave