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!