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

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

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?

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?