Information générale
Titre:
Combo Boxes pointing to Local Views
Hi,
I have 5 combo boxes on a sales order form:
Cobox Box ControlSource
========= =============
cboCustCode lvSO.CustCode
cboBillToCode lvSO.BillToCode
cboBuyerCode lvSO.BuyerCode
cboShipToCode lvSO.ShipToCode
cboTransportCode lvSO.TransportCode
The last four contain only the allowable selections pertaing to a specific Customer which the user will initially choose (cboCustCode).
To do this, in the GotFocus() event of each of the last combo boxes I code:
SELECT BILLTOCODE, BILLNAME,BILLADDRESS1,BILLPROVINCE, BILLPOSTALCODE, BILLPROVINCECODE, BILLCOUNTRYCODE, BILLATTENTION FROM CUSTOMER_BILL_TO WHERE CUSTOMERID=CUSTOMER.ID
I do this for the buyer,shipto, and transport.....
lvSO is a complete local view of SO table.
My problem is that when I move through the local view lvSO, (Next, previous, etc., command buttons on my SO form, the value stored in my last four combo boxes is not displayed, even though the lvSO view and the SO table contain and display the same and identical data!
The selections of the combo boxes are OK.
Why is this happening?
If I replace the combo boxes with text boxes, everything works great, but I can nnot use this solution, because this would require the user have a huge memory and remember all codes for each customer. :0(
Any suggestions?
Thanks in advance!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement