how do you show the Filtered Listbox1 from form A to listbox 2 form b

[princess12]

Hi everyone,



as you can see from my question i want to ask how do you show the Filtered Listbox1 from form A to listbox 2 form b, is it feasible. i know how to copy the value from listbox one to listbox 2, but can a filtered listbox1 results be shown into listbox 2.

here is how the listbox1 is copied to listbox 2. note both listbox are in different forms

[Forms]![formB]!
[listbox2]=[Forms]![formA]!
[listbox1]




thanks for your help

[amrut]

If the list box row source is a table/query, add the Forms!Form!Listbox1 (multiselect not allowed) to the criteria row of the appropriate field of row source of Listbox 2.

[princess12]

thank you for your time,

could you please give me an example, i understand what the criteria is, is it some thing like

Me.lstListbox.RowSource = "SELECT [table].[RNumber],[table].[Rtype],[table].[RPrice] " & _"FROM table LEFT JOIN Booked ON [table].[RNumber] = Booked.RNumber " & _
"WHERE [Booked].[RNumber] Is Null "
[Forms]![formA]!lstListbox.Requery
this is in form A where listbox1 is successfully filtered.
with the same rowsource, the listbox 2 appropriate record is selected on form b. i want whatever filtered in form A to be shown in form b.


thanks a lot

[amrut]

Something like this
Me.lstListbox.RowSource = "SELECT [table].[RNumber],[table].[Rtype],[table].[RPrice] " & _"FROM table LEFT JOIN Booked ON [table].[RNumber] = Booked.RNumber " & _
"WHERE [SomeField] " & [Forms]![formA]!lstListbox " & " AND [SomeMoreField] IS Not Null;"

[princess12]

it not working, and my form A listbox becomes empty, should i send you an attachment so you can see, if it ok.

thanks

[amrut]

zip and attach it here

[princess12]

here is the attached file, thank you

[princess12]

Hi thanks for your help, but i fixed it, thank you very much