Hello,
I have a form which i have been playing with but havent got it quite working how i would like.
I have an access database with dealer name, dealer code, and fmt email. What I have the form doing is displaying the dealer name in a drop down box using dynamic properties with the value being the fmt email. The submit button grabs the rawValue of the drop down and makes it the recipient.
This bit works fine. The problem is, when the form is emailed, the drop down list does not display the selected value. There are five fmt email groups, and 130 dealers. This works out to on average about 25 dealers per group. I am pretty sure the problem is due to when the form is submitted, it maintains the value of the drop down, but since it is not unique, it reverts to the top of the group which was selected as it cannot distinguish which one was actualy chosen.
I tried then using a unique identifier for the drop down, (such as dealer code) making it populate another form, then try and grab the displayed text from that field for the email instead of the rawValue, but I have had no success.
Can anybody please give me some ideas on how i should tackle this? Locking drop down after selection?
regards
Darryl