K
Kojones
I am having issues....
I set up a Combo Box in a Form that, when a record is selected in the combo
box, the other fields in the form display the related information. I thought
it was working wonderfully until I noticed that one field text box does not
display the correct information. My Combo Box is set up to choose "Policy
Number." The nature of our policies is that there can be multiple "riders"
on each policy. This results in the occational duplication of a policy
number in that field with a 0, 1, 2, 3, etc., for the multiple riders. When
I select a policy with a 0 and 1 rider, and select the record listing rider
1, the form always displays the previous record with rider 0. I suspect that
this is because the rest of the form references the policy number and it
reverts to the first available record with that policy number. So, here's my
question: How can I make the form reference the record that includes BOTH
the policy number and the rider (since those combinations are unique)?
I set up a Combo Box in a Form that, when a record is selected in the combo
box, the other fields in the form display the related information. I thought
it was working wonderfully until I noticed that one field text box does not
display the correct information. My Combo Box is set up to choose "Policy
Number." The nature of our policies is that there can be multiple "riders"
on each policy. This results in the occational duplication of a policy
number in that field with a 0, 1, 2, 3, etc., for the multiple riders. When
I select a policy with a 0 and 1 rider, and select the record listing rider
1, the form always displays the previous record with rider 0. I suspect that
this is because the rest of the form references the policy number and it
reverts to the first available record with that policy number. So, here's my
question: How can I make the form reference the record that includes BOTH
the policy number and the rider (since those combinations are unique)?