ListBox; store a number, display a discription

R

RobUCSD

I have a double listbox on a form and in the target list box I want to
display the fldVisitChargeDescription yet in the underlying table I want to
store the corresponding fldVisitChargesDescriptionNo which is a numeric
value. I can change the bound colum in the target list to show the
description, but then it stores the description and not the number. Help!

As always, any help is greatly appreciated.
Thanks, Rob
 
A

AccessVandal via AccessMonster.com

Hi Rob,

Don't know about your form design and listboxes.

My guess is that the target listbox rowsource is something like "Select
description From VisitChargeDescription Where "whatever Id" = "source list
box id""

By default, the target listbox Data tab - Bound Column = 1.

If the target listbox rowsource is something like "Select description,
"whatever ID" From VisitChargeDescription Where "whatever Id" = "source list
box id""

Set the Bound Column = 2, since the SQL second column is the field.
 
Top