L CCI Component subform

The L_CCI_Component subform in the ICD10 tab of the Patient Viewer in CCMDB.accdb is used (together with L CCI Picklist subform) to enter the CCI Component data for CCI Collection.

Form elements

Header:

• button to sort alphabetically
• button to sort by date

Body:

• CCI_1_Code
• CCI_2_Code
• #CCI_Chooser (the "?" button)
• #Duplicator (the "2x" button)
• "*" button to set Px_Date to today
• "+" button to increase Px_Date by one day
• "-" button to decrease Px_Date by one day
• Px_Date
• Px_Type
• Px_Count

CCI_Chooser (the "?" button)

The "?" button opens the CCI_Chooser form where you can filter for a keyword or partial keyword (e.g. "hepa" instead of "hepatic").

Duplicator (the "2x" button)

The 2x button will make a twin of the record on which it was clicked. This is useful for repeat entries like debridements.

Deferred change - Make dropdowns so only allowed are visible

• The dropdowns contain values that are allowed and values that are not allowed. Would be nice to limit to what is allowed. However, since that changes as the other fields are populated, this not straightforward. Tina spent some time on this initially and deferred it. The issue hasn't come up since. If this is a required change, flag it again.

Data storage

See CCI Data Structure