List box Problem

[TC]

Select the columns in order id, name. Bind to column 1. In the Format
properties (from memory), say there are 2 columns to display. Define their
widths (eg. "1cm;5cm" without the quotes). Define the overall width ("6cm").
That should do the trick.

HTH,
TC

 

[James Agostinho]

Hello NG,
I hope someone can help me with a list box problem.
I have a form, frmPurchases, that is bound to the tblPurchases.
On this form I have a list box that is populated from a query that comes
from another table with just 2 fields.
The 2 fields are StoreID (Int data type) and StoreName (text data type) in
the tblStores table.
I would like to have the list box show the store name, but put the storeID
in the new record when I add a new purchase.
I have tried to bind the column 1 and show column 2 but I either get a data
type mismatch or just the StoreID shows and I can't see the StoreName. Can
anyone please help me get this right?
TIA
James

 

[Albert D. Kallal]

You need to make sure the bound field is a long data type.

This should let you store the id, and display the name...

 

[James Agostinho]

Thanks,
TC and Albert.
Both of you helped me with the suggestions, I go the right data type and
reformatted the column width, something I didn't know you could do
(different widths on different columns) and now it works
James