Shown all record in a list box from combobox.

[shiro]

Hi all,
I have a listbox that can be filtered from a combo box.
Now I want the combobox has an option ( called ALL ),
so when the combobox value is ALL,all the data in listbox
is shown.

Below is the SQL of my lisbox records source :

SELECT [Model specification_tbl].Model
FROM [Model specification_tbl]
WHERE ((([Model specification_tbl].Model) Like [Forms]![Start input
data_frm]![cbo_fourdigitsmodel] & "*"))
ORDER BY [Model specification_tbl].Model;


Thank's for your help.

 

[Stefan Hoffmann]

hi shiro,

Hi all,
I have a listbox that can be filtered from a combo box.
Now I want the combobox has an option ( called ALL ),
so when the combobox value is ALL,all the data in listbox
is shown.

Take a look at

http://msdn2.microsoft.com/en-us/library/bb457185.aspx



mfG
--> stefan <--