Thanks for the note Sietse. I already had the Drop-down list selected and mentioned only the data related properties because I thought there might be a way to initialize the control without needing to index the cursor and seek to the last name. - Joe
On Friday, September 19, 2008 4:02 AM, Sietse Wijnker wrote: > >Date: Fri, 19 Sep 2008 10:02:12 +0200 >From: Sietse Wijnker >To: [EMAIL PROTECTED] >cc: >Subject: RE: Newbee - Best practice for ComboBox control with a list froman >outside source > >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] ** 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.
