Query on a Form

[darkyetlovely39]

What I have is an unbound combo box on my form that I can select a Session number from (1, 2, or 3). When I click on my command button "OpenQuery" it opens my Classes Query with classes listed in that session.



In each session there are four periods, so I would also like to filter out the query by period number within the session number. Is this possible?

[alansidman]

Look at this video tutorial and it will show you how to do what you are trying to do.

http://www.datapigtechnologies.com/f...earchform.html

Alan

[darkyetlovely39]

Unfortunately, my computer has no speakers.

Is it simple enough for you to explain it to me? Also, I tried to post my DB but it just barely exceeded the size limit...

[alansidman]

Two thoughts. Can you plug a headset into your computer so that you can listen. Mike does a much better job of explaining this.

As to posting your db. Do a compact and repair and see if it is small enough. If not, then put inside a zip file and then post.

Alan

[darkyetlovely39]

No headset. Perhaps I can look at it later with my home PC...

Here's my DB: Attachment 3430