Subform problem with unique-table-property set in access adp

[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

[Simon Hayes]

"Filips Benoit" <be***********@pandora.be> wrote in message
news:uG**********************@phobos.telenet-ops.be...

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

You will probably get a better response to this in an Access group, as it
seems to be more of an ADP issue than an MSSQL one.

Simon