Hi Joe, You've missed one property: Style. Set it to 2 (Drop-down list box) in stead of 0 (Drop-down combobox) >From the help: 'Drop-down combo box, which includes a list box and an edit box. (Default) The user can select from the list box or type characters in the edit box.'
Regards, Sietse Wijnker SW-Software -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Joe Yoder Verzonden: vrijdag 19 september 2008 1:04 Aan: [EMAIL PROTECTED] Onderwerp: Newbee - Best practice for ComboBox control with a list from an outside source My application builds a cursor, Customers, of customer names and ids from QuickBooks. I want my user to select a valid customer from that cursor via a ComboBox. That seems to work with ComboBox properties : BoundColumn = 1 ControlSource = Customers.Fullname RowSource = Customers.Fullname RowSourceType = 6 - Fields The form should initialize with the ComboBox initialized to the same customer as the previous transaction. I have tried initializing the ComboBox.value with the old customer name saved from the previous transaction and it appears to work but if the old customer name is no longer in the Customers cursor, some random? record gets overwritten with the old value. I will probably index the Customer cursor and have the initialization code set near on to seek for the old customer name, but I thought someone with experience might suggest a better/simpler approach. Thanks in advance for any comments - Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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]@sw-software.nl ** 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.
