Can you please advise how to hide specific values from a combobox list?
For example: I have a main form which is used to either display previously created records or can be used to create new records. When the form is loaded to display a history record, the combobox cboErrorCat displays, Error1, Error2, Error3, Error4 when selected. What I require is for the cboErrorCat to display only Error1 and Error2 when the form is loaded to create a new record.
Main Form is called frmPaymentError, combobox is named, cboErrorCat and the row source for the cboErrorCat combobox is called qryErrorCategories
SELECT tblErrorCategories.ErrorCategoryID AS Expr1, tblErrorCategories.ErrorCategory AS Expr2
ORDER BY tblErrorCategories.Order;
Any assistance would be much appreciated.
Thanks in advance.