I created a form based on a query.
When somenoe chose a certain number, I needed for it to fill in other fields once that number was chosen...that was accomplished...BUT...what if someone adds a number that is not in the list. I do have the Limit to LIst set to No. When I type in a number that is not in the combo box, it will not add it to the table...along with all the other fields that need to go with that combo box.
The tables are Cancel and Deal.
Ex:
#: 120000
Contact: Bob
Phone: 123-456-7890
Updated: =Date()
I would need that to be updated in the Deal table.
I think I might know what the problem is but if I fix that, it screws me up some other way.
1) If i change the combo box to the one in the Deal table, I suppose it would add that to the Deal Table, BUT, since those numbers are not to be duplicated, it will give me a message saying its a duplicate value.
2)If I have the combo box from the Cancel table, it won't give me the duplicate value message but it won't add the info to the Deal table.
Any suggestions?
THanks!
When somenoe chose a certain number, I needed for it to fill in other fields once that number was chosen...that was accomplished...BUT...what if someone adds a number that is not in the list. I do have the Limit to LIst set to No. When I type in a number that is not in the combo box, it will not add it to the table...along with all the other fields that need to go with that combo box.
The tables are Cancel and Deal.
Ex:
#: 120000
Contact: Bob
Phone: 123-456-7890
Updated: =Date()
I would need that to be updated in the Deal table.
I think I might know what the problem is but if I fix that, it screws me up some other way.
1) If i change the combo box to the one in the Deal table, I suppose it would add that to the Deal Table, BUT, since those numbers are not to be duplicated, it will give me a message saying its a duplicate value.
2)If I have the combo box from the Cancel table, it won't give me the duplicate value message but it won't add the info to the Deal table.
Any suggestions?
THanks!
