Hi,
I am new to VBA (and Access). I am trying to populate my two combo boxes but keep getting a run-time errror 2465.
This is what I have so far:
Private Sub PopRptType()
'Add list entries to Report Type Combo Box
With cbxRptType
AddItem "Select Chart or Report Type", [Index 0]
AddItem "Pareto Chart", [Index 1]
AddItem "RCA Event Summary Table", [Index 2]
AddItem "Unused1", [Index 3]
AddItem "Unused2", [Index 4]
End With
End Sub
Private Sub PopConstraint()
'Add list entries to Report Contraint Type Combo Box
With cbxConstraint
AddItem "Select Constraint Type", [Index 0]
AddItem "Part Number", [Index 1]
AddItem "RCA Event Type", [Index 2]
AddItem "RCA Event Category", [Index 3]
AddItem "Work Area or Cell", [Index 4]
AddItem "RCA Event Status", [Index 5]
End With
End Sub
Private Sub frmReportsCharts_Load()
PopRptType
PopConstraints
End Sub
Any help would be greatly appreciated. Thanks.