I want to include a CombBox in a form and only display certain records, the combobox will reference a table for all the records, however I only want specific records to be displayed.
For example, say I have:
Column1 Column2 Column3
Where Column1 and Column 2 have to different piece of information, i.e. first name and last name, opr item name and price. And Column3 can contain certain values, i.e. M/F or Yes/No.
How would I limit the ComboBox to display records which only say Yes for Column3 and not every record.
For example, say I have:
Column1 Column2 Column3
Where Column1 and Column 2 have to different piece of information, i.e. first name and last name, opr item name and price. And Column3 can contain certain values, i.e. M/F or Yes/No.
How would I limit the ComboBox to display records which only say Yes for Column3 and not every record.