F
Filips Benoit
Dear All,
W2000
Office2000
Access adp
SQLserver DB
Problem:
Adding a new property for a company in the subform.
The FIRST time I Select a property in combobox CPROP_PRP_ID the subform act
strange.
1. The selected value doen't show in the combobox!
2. The sortorder of the subform changes!
Reselecting the same value in the combobox acts normal and adding gives no
problem.
Adding a second property for the same company acts normal.
Please HELP, I can't solve this problem!
All specifications below.
Tables:
COMPANY: COM_ID, COM_NAME, etc.
PROPERTY: PRP_ID, PRP_NAME, ETC.
COMPANY_PROPERTY: CPROP_COM_ID, CPROP_PRP_ID, CPROP_VALUE
FRM_COMPANY: source = table COMPANY
SUBFRM_COMPRP:
1. SubFrm source = view (see sql)
SELECT COMPANY_PROPERTY.CPROP_COM_ID,
COMPANY_PROPERTY.CPROP_PRP_ID,
PROPERTY.PRP_NAME,
COMPANY_PROPERTY.CPROP_VALUE
FROM dbo.COMPANY_PROPERTY INNER JOIN
dbo.PROPERTY ON
dbo.COMPANY_PROPERTY.CPROP_PRP_ID = dbo.PROPERTY.PRP_ID
2. SubFrm: Order By = ViewComPrpsSubFrmSource.PRP_NAME to sort by
PROPERTY.PRP_NAME
3. SubFrm: Unique table = COMPANY_PROPERTY
4. Controls:
4.1.combobox that holds CPROP_PRP_ID (Rowsource=SELECT PRP_ID, PRP_NAME FROM
PROPERTY WHERE (PRP_COMPANY = 1) ORDER BY PRP_NAME)
4.2. CPROP_VALUE
W2000
Office2000
Access adp
SQLserver DB
Problem:
Adding a new property for a company in the subform.
The FIRST time I Select a property in combobox CPROP_PRP_ID the subform act
strange.
1. The selected value doen't show in the combobox!
2. The sortorder of the subform changes!
Reselecting the same value in the combobox acts normal and adding gives no
problem.
Adding a second property for the same company acts normal.
Please HELP, I can't solve this problem!
All specifications below.
Tables:
COMPANY: COM_ID, COM_NAME, etc.
PROPERTY: PRP_ID, PRP_NAME, ETC.
COMPANY_PROPERTY: CPROP_COM_ID, CPROP_PRP_ID, CPROP_VALUE
FRM_COMPANY: source = table COMPANY
SUBFRM_COMPRP:
1. SubFrm source = view (see sql)
SELECT COMPANY_PROPERTY.CPROP_COM_ID,
COMPANY_PROPERTY.CPROP_PRP_ID,
PROPERTY.PRP_NAME,
COMPANY_PROPERTY.CPROP_VALUE
FROM dbo.COMPANY_PROPERTY INNER JOIN
dbo.PROPERTY ON
dbo.COMPANY_PROPERTY.CPROP_PRP_ID = dbo.PROPERTY.PRP_ID
2. SubFrm: Order By = ViewComPrpsSubFrmSource.PRP_NAME to sort by
PROPERTY.PRP_NAME
3. SubFrm: Unique table = COMPANY_PROPERTY
4. Controls:
4.1.combobox that holds CPROP_PRP_ID (Rowsource=SELECT PRP_ID, PRP_NAME FROM
PROPERTY WHERE (PRP_COMPANY = 1) ORDER BY PRP_NAME)
4.2. CPROP_VALUE