If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo Box Data Loss
I have finally haad my initial problem of populating a txt box vale from a
combo box selection (thanks to Tony, when i actually closed the form down and re opened the form it worked). Then picked up a virus which has caused porblems and lost my thread on the web. Now i have a new related problem When I select a value from the combo box it does poulate the txt box value with the value that i required, but it changes the values of the other combo boxes of the next record too. Also when i close the form and reopen it the value is gone. Is there anything i can do to retain the value that has been saved without changing the next customer invoice details or losin its value upon closing |
#2
|
|||
|
|||
Combo Box Data Loss
Hi
It sounds to me as if the textbox is unbound to a field ?? How are you setting the value of the text box (what is the code you are using - can you post it) -- Wayne Manchester, England. Enjoy whatever it is you do Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "tboyce" wrote: I have finally haad my initial problem of populating a txt box vale from a combo box selection (thanks to Tony, when i actually closed the form down and re opened the form it worked). Then picked up a virus which has caused porblems and lost my thread on the web. Now i have a new related problem When I select a value from the combo box it does poulate the txt box value with the value that i required, but it changes the values of the other combo boxes of the next record too. Also when i close the form and reopen it the value is gone. Is there anything i can do to retain the value that has been saved without changing the next customer invoice details or losin its value upon closing |
#3
|
|||
|
|||
Combo Box Data Loss
Hi there Wayne, thanks for replying the code i was kindly told to enter in
the after update event of the combo box to: Private Sub cboCustomerName_AfterUpdate() If Not IsNull(cboCustomerName) Then Me.CustName = Me!cboCustomerName.Column(1) End If End Sub this does the job but when i go to record 2, 3 or whatever it has changed the value of that record too. Hope this helps. Thanks "Wayne-I-M" wrote: Hi It sounds to me as if the textbox is unbound to a field ?? How are you setting the value of the text box (what is the code you are using - can you post it) -- Wayne Manchester, England. Enjoy whatever it is you do Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "tboyce" wrote: I have finally had my initial problem of populating a txt box value from a combo box selection. (thanks to Tony, when i actually closed the form down and re opened the form it worked. Then picked up a virus which has caused porblems and lost my thread on the web). Now i have a new related problem When I select a value from the combo box it does poulate the txt box value with the value that i required, but it changes the values of the other combo boxes of the next record too. Also when i close the form and reopen it the value is gone. Is there anything i can do to retain the value that has been saved without changing the next customer invoice details or losin its value upon closing? |
#4
|
|||
|
|||
Combo Box Data Loss
I have another combo box on my form which is bound to column but that does
the same thing. I have noticed that it only changes each second entry. By that i mean, recird 1 and two are the same record 3 & 4 are the same and so on. What is going on??** What do u mean by post it Wayne? Hope you haven't forgotten my plight. Thanx 4 help every1 "tboyce" wrote: Hi there Wayne, thanks for replying the code i was kindly told to enter in the after update event of the combo box to: Private Sub cboCustomerName_AfterUpdate() If Not IsNull(cboCustomerName) Then Me.CustName = Me!cboCustomerName.Column(1) End If End Sub this does the job but when i go to record 2, 3 or whatever it has changed the value of that record too. Hope this helps. Thanks "Wayne-I-M" wrote: Hi It sounds to me as if the textbox is unbound to a field ?? How are you setting the value of the text box (what is the code you are using - can you post it) -- Wayne Manchester, England. Enjoy whatever it is you do Scusate,ma il mio Inglese fa schiffo :-) Percio se non ci siamo capiti, mi mandate un messagio e provero di spiegarmi meglio. "tboyce" wrote: I have finally had my initial problem of populating a txt box value from a combo box selection. (thanks to Tony, when i actually closed the form down and re opened the form it worked. Then picked up a virus which has caused porblems and lost my thread on the web). Now i have a new related problem When I select a value from the combo box it does poulate the txt box value with the value that i required, but it changes the values of the other combo boxes of the next record too. Also when i close the form and reopen it the value is gone. Is there anything i can do to retain the value that has been saved without changing the next customer invoice details or losin its value upon closing? |
Thread Tools | |
Display Modes | |
|
|