Ed
Many thanks - easy when you know how !
Paul Newton
----- Original Message -----
From: "Ed Leafe" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: 07 January 2008 13:25:57 o'clock (GMT) Europe/London
Subject: Re: Dropdown list
On Jan 7, 2008, at 7:10 AM, Paul Newton wrote:
> I have a numeric field for which the allowable values are 0, 4, 6,
> 8, or 12 and a form with a dropdown list. The rowsourcetype for
> the list is 1 (value) and I have set the rowsource to be 0,4,6,8,12
> and the controlsource to be the numeric field.
>
> This does not work because when the displayvalue is 8, the value is
> 4 and that gets stored in the field (and vice versa - if the value
> in the field is 4, the listbox shows the value 8)
>
> Can anybody please suggest how I *should* be doing this ?
Check out the 'BoundTo' property. When .F. (default), it stores the
index of the selected item instead of the value. Change it to .T. to
bind the actual value instead.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
