Hi all,
I have a form with some unbound combo's and a list box that are used to
requery the dataset behind the form.
All was working fine until i added the list box.
I have the record set of the form looking at that value sin the combo
boxes and handling everything loverly but when i try to use the data
from the list box, it all goes a bit wierd...
I want someone to be able to have a blank in the list box and get
everything or click on one or more items in the list box and get those
items only... it's not difficult right??? But null's have left me in a
dilema and i'm struggling to get this working...
After much faffing about i have the following criteria in the list box
field selection:
Like IIf([forms]![frm_audit_form]![listbox] Is
Null,"*",[forms]![frm_audit_form]![listbox]) Or In
([forms]![frm_audit_form]![listbox])
So if I just use 'In' the list and the list is blank i don't get
everything...
I'm obviously missing the point and i'm sure i've had this working once
before at another company i worked at but I just can;t remember how...
Any ideas? Do you need more info to bea ble to help???
many Thanks,
Rob.