Updating textbox - combobox per record

[vincentsp]

Hi All,



In my form I have created a textbox which shows me the information from a combobox using a AfterUpdate event.
This works fine but once I go to any other record in the database the textbox keeps the value from the last saved record.

How do I get the textbox save the specific value chosen from the combobox per record.
This would also help me using the textbox values in my query later on.

[NTC]

It sounds like your textbox is not bound. If that is the case then use a different technique. Do not write into it using the Afterupdate event. Instead source is on the combobox i.e.: =Me.ComboboxName.column(2)
....I just made up the number 2 - you'll of course use whichever value is correct.....

In this way the text box will change value each time you change record and the value of the combobox changes

[vincentsp]

Thanks for your fast reply. It solves part of my problem.
The values in my textbox controlled by the combobox are correct now and saved per record!.
But in my query it does not show the textbox value per record, but gives the textbox value of the selected record in my form for each record in the query.

[amrut]

The values in my textbox controlled by the combobox are correct now and saved per record!.

Since the textbox is unbound as predicted by NTC, the text box is only displaying the value based on combo box value and not saving it. To save it, the control source of the text box should be a field from the table on which the form is based.

[vincentsp]

Thanks a lot I created a bound textbox and I'm able to use the value in my query as well.