Combo Box Data Loss

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

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.

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?