Text Box level and unit no won't save to table field Level and unitno

[aligahk06]

Dear All,



The previous thread related to topic is solved .

today i noticed that the below control source property won't save the value in table.

Assuming you have a text box called "Level" and another called "unitno".

Set the Control Source property of text box "Level" to =[Combo78].column(1)
Set the Control Source property of text box "unitno" to =[Combo78].column(2)
it working fine with combo and display the value from combo but it won't save the value in table.


Any help !!!

[CJ_London]

you need to bind your textboxes to the fields in your table and use vba to assign the values - usually in the afterupdate event of your combo

me.txtLevel=[Combo78].column(1)
me.txtunitno=[Combo78].column(2)

or alternatively in the form beforeupdate event

Level=[Combo78].column(1)
unitno=[Combo78].column(2)

strongly recommend you give your controls meaningful names

[aligahk06]

after running value out of context You can't assign value to this object

Private Sub Combo78_AfterUpdate()
Me.Level = [Combo78].Column(1)
Me.UnitNo = [Combo78].Column(2)
End Sub

[Gicu]

With this code you need to set the control source of the two test boxes to be the two fields from the table, not to reference the combo's columns.

Cheers,

[davegri]

As ajax says, on the form, set the control source for the textboxes to the field names so as to bind them.
You can't set the VALUES equal to an expression if the VBA is doing the same.

[aligahk06]

I want to save value from combo selection to table.
Please see the attached DB.
after running value out of context You can't assign value to this object

Private Sub Combo78_AfterUpdate()
Me.Level = [Combo78].Column(1)
Me.UnitNo = [Combo78].Column(2)
End Sub

[Bob Fitz]

See db Attached:

[aligahk06]

Sir Bob Fitz,
I can't understand the language of attached DB.

[Bob Fitz]

Sir Bob Fitz,
I can't understand the language of attached DB.

I'm very sorry. Somehow I managed to attach the wrong db.
please see attached:

[aligahk06]

THanks a lot for precious time.