- Joined
- Jan 27, 2014
- Messages
- 4
- Reaction score
- 0
I have a combo box that displays a list of accounts, when an account is selected it shows the representatives for that account in another combo box. at the bottom of the form there is a submit button to add these values and some other information to a separate table. I have the second combo box filled off of a query.
My problem is that when I submit my form rather than carrying over the account name to the table it carries over the Key number for the account. At first it was doing this for both the representative and the account. I was able to fix this for the rep box but cannot seem to get it work for the Account box.
My problem is that when I submit my form rather than carrying over the account name to the table it carries over the Key number for the account. At first it was doing this for both the representative and the account. I was able to fix this for the rep box but cannot seem to get it work for the Account box.