Paul, You need the:
BoundTo=.T. And the BoundColumn set to the relevant "Bound Variable" Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: 07 January 2008 13:11 To: profox Subject: Dropdown list Hi all 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 ? Thanks Paul Newton [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.
