Hi
In quite a few places I need combo boxes that have the first item as a blank entry, with an associated value of, say 1000.
I need this for filter purposes so that the combo box for that field stops filtering when the blank option is selected. I use VB to tie together all the different combos and form the appropriate filter clause.
In some cases I am able to place a blank entry directly into a lookup table, which works, however in many other places I have queries that I do not know how to add this blank field and value to.
Is there any way that I can add a row to a query resultset using SQL? Or how else might I do it?
Thanks in advance,
Mike
In quite a few places I need combo boxes that have the first item as a blank entry, with an associated value of, say 1000.
I need this for filter purposes so that the combo box for that field stops filtering when the blank option is selected. I use VB to tie together all the different combos and form the appropriate filter clause.
In some cases I am able to place a blank entry directly into a lookup table, which works, however in many other places I have queries that I do not know how to add this blank field and value to.
Is there any way that I can add a row to a query resultset using SQL? Or how else might I do it?
Thanks in advance,
Mike
Should've remembered that...!!
