update a listbox (1 Viewer)

[maravinds]

Hallo Everyone,

I have a problem in linking the forms. I have a form called FORM1 and i have 2 comboboxes there. Now I have also a listbox in the same form and in this case I need to update the values in connection with the values that are given in the combo boxes. Can anyone say me how the updates are done automatically in the listbox.


thanks,


aravind.s

 

[Smart]

Create a query that uses the values in the combo boxes as parameters
forms![yourform]![combox1]
forms![yourform]![combox2]

Base your listbox on the query

in the after update of combox2
type me!listboxname.requery

 

[maravinds]

Hai,

thanks!!! that worked for me but there is one more small problem. in the initial stage if both of the combo boxes are empty i need to display all the values and then if any value is selected i need to filter accordingly.

so in short the default value of the combobox must be all. How can this be done.

thanks,

aravind.s