filed in listbox

[Kay]

Hi
I am using a listbox to view all my records in one of my tables. The
problem I have is with the field "Streen Name". This is a lookup field
from the table "streets" which contains all the streets, postcodes and
area.
The problem Im having is the filed street name shows the postcode
instead of the street name (postcode is the primary key) so it is
looking at column (0) and not column(1).
Has anyone any idea how I can get a field in the listbox to refer to
column(1) instead of (0).

I have tried using the query builder and taking the "tick" off postcode
but that messes things up more.

Can anyone help please, hope it makes sense what ive put down

Thanks

[HS Hartkamp]

Behind the listbox is usually a query. The property 'bound column' links the
value of the box to the desired column. The property 'column widths' sets
the part that is visible.

e.g. If the query returns ProductID, ProductGroup and ProductName, the bound
column would be 1 (to the ID) and the column widths would be 0;2;3 to hide
the ID and show the ProductGroups and ProductNames.

Does this help ?

Bas Hartkamp.
"Kay" <kh******@hotmail.com> schreef in bericht
news:11*********************@g10g2000cwb.googlegro ups.com...

Hi
I am using a listbox to view all my records in one of my tables. The
problem I have is with the field "Streen Name". This is a lookup field
from the table "streets" which contains all the streets, postcodes and
area.
The problem Im having is the filed street name shows the postcode
instead of the street name (postcode is the primary key) so it is
looking at column (0) and not column(1).
Has anyone any idea how I can get a field in the listbox to refer to
column(1) instead of (0).

I have tried using the query builder and taking the "tick" off postcode
but that messes things up more.

Can anyone help please, hope it makes sense what ive put down

Thanks