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_PROPERT Y: CPROP_COM_ID, CPROP_PRP_ID, CPROP_VALUE

FRM_COMPANY: source = table COMPANY
SUBFRM_COMPRP:
1. SubFrm source = view (see sql)
SELECT COMPANY_PROPERT Y.CPROP_COM_ID,
COMPANY_PROPERT Y.CPROP_PRP_ID,
PROPERTY.PRP_NA ME,
COMPANY_PROPERT Y.CPROP_VALUE
FROM dbo.COMPANY_PRO PERTY INNER JOIN
dbo.PROPERTY ON
dbo.COMPANY_PRO PERTY.CPROP_PRP _ID = dbo.PROPERTY.PR P_ID
2. SubFrm: Order By = ViewComPrpsSubF rmSource.PRP_NA ME to sort by
PROPERTY.PRP_NA ME
3. SubFrm: Unique table = COMPANY_PROPERT Y
4. Controls:
4.1.combobox that holds CPROP_PRP_ID (Rowsource=SELE CT 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_PROPERT Y: CPROP_COM_ID, CPROP_PRP_ID, CPROP_VALUE

FRM_COMPANY: source = table COMPANY
SUBFRM_COMPRP:
1. SubFrm source = view (see sql)
SELECT COMPANY_PROPERT Y.CPROP_COM_ID,
COMPANY_PROPERT Y.CPROP_PRP_ID,
PROPERTY.PRP_NA ME,
COMPANY_PROPERT Y.CPROP_VALUE
FROM dbo.COMPANY_PRO PERTY INNER JOIN
dbo.PROPERTY ON
dbo.COMPANY_PRO PERTY.CPROP_PRP _ID = dbo.PROPERTY.PR P_ID
2. SubFrm: Order By = ViewComPrpsSubF rmSource.PRP_NA ME to sort by
PROPERTY.PRP_NA ME
3. SubFrm: Unique table = COMPANY_PROPERT Y
4. Controls:
4.1.combobox that holds CPROP_PRP_ID (Rowsource=SELE CT 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