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

  • Thread starter Thread starter Filips Benoit
  • Start date Start date
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
 
Hi,

Sometimes these issues resolve themselves if you recreate
the subform from scratch in ADP. Something happens to the
subform during upsizing I think.
 
Back
Top