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
---

_______________________________________________
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.

Reply via email to