Filter List in Separate Form

[Guest]

I am having a problem getting a list box to show only the records that are
determined in a previous form.

Specifically, form1 (search) allows selection from a list of variable names.
The event procedure is upon dbl click form2 (results) opens and has a big
list box to display the selected variable. Both draw the list of variables
from the same table, however, the list box in the results form displays all
records. I tried to insert a line in the code to define linkcriteria, but my
knowledge of VBA is sorely lacking.

I also tried just limiting the criteria in the results listbox to ones
matching the variable name selected in the search listbox, but nothing
happens. The listbox in the results form is blank.

I'm sure this is a simple problem to solve...could somebody help?

 

[Brian Bastl]

Hi grad,

trying to get my head around your setup. I suspect that I'm not alone since
you haven't received any replies thus far.

On your search form, are you using a listbox to display your search results,
or are you simply using the search form to input search criteria and wanting
to display the search results on the second form in a list box or subform?

Brian

 

[Guest]

Hi grad,

trying to get my head around your setup. I suspect that I'm not alone since
you haven't received any replies thus far.

Oh That was the problem! though i'd been relatively clear, but guess not.
Oh well. I fixed the problem on my own as it turns out. For some reason,
just having criteria in the second forms listbox wasnt working, so i deleted
both list boxes, made them again, typed in the same stuff, and it works now.

thanks for the reply however...