Unanswered: creating a list box from table with an extra item
i have a list box which its row source is a table. but i want to add anothe extra item ("All Items" with value number 0) to this listbox. this is for filter page that goes to report page.
how can i add this?
tanX Sinndho, & a relevant question:
i made that form with All-Types(id=0) & list of Types from tblTypes.
now i come to make report & i made it.
when user select All-Types(id=0) from the list, report must show all the products whith any types, for this i put this code in report Filter:
type_id = IIf(TempVars!type=0, X , TempVars!type)
what am i suppose to put in this expression for X ?