By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Update a text box in regard to the item seleted in the combo box

P: 6
i am trying to implement an application in order to keep rercords of the stationary of a company. i have a combo box named ComboP_Name In FormProducts form,which is getting the values from the ProductName field of products table and ActualQOH is the table which is getting the corresponding quantity on hand value from the same table, the problem is it does not work that way. when i select the product i want from the combo box the textbox does not get the corresponding value. if i still try to update it will generate a msg saying

"the cahnges you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Chnage the data in the field or fields thatcontain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again"

i am not trying to update the primary key of the products table which is the ProductName, i am just trying to update the Qty on Hand.
but when i use the navigation keys o when i enter a number their it will redirect to the product i want and update the qty on hand.

i need help and need to hand this over by tomorrom. i have lyk 21 hours...
thanx in advance
Dec 7 '09 #1
Share this Question
Share on Google+
6 Replies

P: 6
i got tym till 2mro....plz guys...can sm1 plz help me put hea..thanx
Dec 8 '09 #2

P: 167
The problem here must be in the way you join your tables.
If you want you could attach a sample DB here or send it to me directly and I could help you with that right now.
Dec 8 '09 #3

P: 6
No joined tables are used in this particular form. I dont know y. i have mailed u the DB. please can u check that and let me know. thanx for ur concideration..
Dec 9 '09 #4

P: 6
plz. can SOME ONE check this attatchment and advice me on what i shud do..thnx
the problem is occuring on form "Products"

Dec 9 '09 #5

P: 7
I might have miss interpreted your question... but a possible solution might be to edit the control source of the text box to display the stored value in the combo box.

In the property sheet , add in "=[Forms]![ProductName]![ComboP_Name]" without the quotes
Dec 9 '09 #6

P: 6
thanx.... but it doesnt seem to be wrkin.... my issue is i can select an item from the combo by going thru the data 1 by 1. and also can use that scroll thing of the mouse to navigate trhu the items. but wen i click on the combo(when it drops down) i can select an i tem...
guess this is clear...f not pls lemme kno..thanx
Dec 9 '09 #7

Post your reply

Sign in to post your reply or Sign up for a free account.