Update Table

[tranzit]

I currently have a form with a combo box, text box and a button. When a selecetion is made from the combo box the corresponding data from the table is displayed in the text box.

I want the button set up to update the table with any changes made to the data displayed in the text box.

What code is required behind the button???

Can anyone help???

[MMcCarthy]

I currently have a form with a combo box, text box and a button. When a selecetion is made from the combo box the corresponding data from the table is displayed in the text box.

I want the button set up to update the table with any changes made to the data displayed in the text box.

What code is required behind the button???

Can anyone help???

There isn't really enough information here to give you more than a basic direction. However, the first thing I can think of is to set the control source for the textbutton to the corresponding field in the table.

[tranzit]

wat more do u want to know?

[MMcCarthy]

What is the name of your form?
Is the form bound to a record source?
What is the name of the controls, including the combo box, textbox and command button?
What is the control source of the combo box and textbox?
What is the row source of the combo box?
What code is being used to populate the textbox?

[tranzit]

Form Name: Form1

Form bound to record source: Yes, Table1

Name of controls: Combobox - Combo1, Textbox - Text1, Button - Button1

Control source of combo and text boxs: no control source for combo box, text
box control source is a column
called "123"

Row source for combo box: SELECT * FROM Table1 ORDER BY id;

Code to populate text box: Private Sub Combo1_AfterUpdate()
Me!Text1 = Me!Combo1.Column(1)
End Sub

[tranzit]

Can Someone please help me?????