By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,639 Members | 2,340 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,639 IT Pros & Developers. It's quick & easy.

Subform problem with unique-table-property set in adp

P: n/a
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
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.