I have a list of bill numbers (column name BillNO) that I want to populate a combo box and restrict the list of items to all bill numbers not listed in the datagrid. How do I do this? See attached screen print of example. When we put logic in the query for the combo box to exclude the items already in the table, when the data shows on the form the BillNO field is blank.
Thank you for your assistance.