• 0

[Access] Subform conditions?


Question

Howdy, I've got a mini database, and got a slight problem with my Forms...

  • There's the main CUSTOMER form. Inside that is the TRANSACTION subform.
  • At the top of my CUSTOMER form, I've made a list box so I can select the CUSTOMER. When I select this, this changes all the values in the subform to only show me TRANSACTIONS for that particular customer. Sweet no problems.
  • Now, I make another list box at the top of the CUSTOMER form. In this one, I put in all the Months (values 1, ... ,12). When I click on this it is meant to select only the TRANSACTIONS that are related to that month. (I did this by changing the WHERE condition for the RecordSource of the subform).

So my problem: it works but only "sometimes" - I'll click on a CUSTOMER's name. Then I'll click on a Month. It doesn't change! But then I click on another CUSTOMER's name, and then change the month to something else, then change it back: it changes and works! :( Bizarre.

My guess is that I need to have some sort of "update the TRANSACTION subform on selecting/clicking a different CUSTOMER name or MONTH from the list boxes". Could that be it? How do I fix that? Or any other ideas? :) Cheers!

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.