Comobox adjusted list items

[mba_110]

Hi everyone

I have a table tblAccountsHearder which store the headings of account (not accounts) under each account Heading there are several accounts listed in tblAccounts.

I have combo box on frmAddNewAccount name is cboType in this combo box my row source is

SELECT tblAccountsHeader.HeadingName FROM tblAccountsHeader GROUP BY tblAccountsHeader.HeadingName;

let you give you example of what i want to achieve.

for example:
(lets say i have 50 list items in HeadingName column which appear in combobox row source as i mentioned above.

Secondly i want some list items to remove from combo box but not from the table data.

lets say i have combo box list (1,2,3,4,5,6,7,8,9,0) and i want combo box should not show me (1,5,0) in above list then combo box list should show me (2,3,4,6,7,8,9) only....)

I can type it manually also for beginning it ok but in future when data increased i cant easy to add each one manually.

Any help in doing that will be great.

 

[Gasman]

Mark the ones you want as active and only select those for the source?

 

[mba_110]

What if i dont want to go with table and try it sorting out in combo box sql query?

Is it possible?

 

[June7]

Why would these 3 items not be included? What would be criteria for filtering them out?

 

[Gasman]

What if i dont want to go with table and try it sorting out in combo box sql query?

Is it possible?

A query gets it's data from a table or another query?, so you have to store whether you want to see an item or not, in some way.?

 

[MajP]

What if i dont want to go with table and try it sorting out in combo box sql query?

Is it possible?

Select HeadingID, HeadingName from TableHeadings where HeadingID NOT IN (1,2,3,7,11) ORDER BY HeadingName

https://www.w3schools.com/sql/sql_in.asp