I have a continuous form whose data comes from a query, and I have a combo box with values that I entered myself in the Form header.
What I want to do is when I select a value in the combo box, the corresponding detail information changes.
For example my combo box is called claim status, it has the values of Open and Closed, I also have a textbox called Claim Status in the Detail section. If I select the Open value I want the information in the Detail section to change to show all records whose Claim Status value is equal to Open, and the same for closed.
Can anybody help me?
What I want to do is when I select a value in the combo box, the corresponding detail information changes.
For example my combo box is called claim status, it has the values of Open and Closed, I also have a textbox called Claim Status in the Detail section. If I select the Open value I want the information in the Detail section to change to show all records whose Claim Status value is equal to Open, and the same for closed.
Can anybody help me?
