Filtering the contents of a list box

[Garry E]

Hi there, I have filtered the contents of a form using a
macro. How ever when I put a list box on the form it
returns all records and not the filtered ones on the form.
Any suggestions?? Thnaks in advance. Garry E

 

[Jim/Chris]

the filter of the list box is not related to the form. You
must filter the listbox separatly. In design view of the
form select the listbox control and go to properties. Go
to row source and click the three ... Then edit the query
to create the filter


Jim