Coding for a Search Command Button

[Mac]

I created a form for searching records with a "Search"
command button that has the following code:

Private Sub cmdSearch_Click()
Me.lstSection.Requery
End Sub

Everything works fine with this form.


However, I tried to create another form using similar
techniques and it won't work.
I've checked spelling, criteria in the queries etc. Both
forms are very similar so my guess is the problem is with
the coding, which is:

Private Sub cmdSearch2_Click()
Me.lstTech.Requery
End Sub

I can elaborate if necessary.
Thanks in advance
Mac

 

[Randy Harris]

Mac, it's going to be tough for anyone to help if you don't define what you
mean by "it won't work". Suggest you include what you expect to happen as
well as what actually happens.

My 2 cents worth,
Randy

 

[Guest]

Thanks for responding, but I figured it out.

 

[Mac]

thanks for your reply, i figured it out