Afterupdate

[hermie]

Hello

I put this simple event in my afterupdate but it not works?
I got error message object required?

I tried:

Private Sub cbotarea_AfterUpdate()
Me.cbotarea.Column(2).value = Me.Txtvalor.value
End Sub

I also tried:

Private Sub cbotarea_AfterUpdate()
Me.cbotarea.Column(2) = Me.Txtvalor
End Sub

What goes wrong here?

Herman

 

[Douglas J. Steele]

You can't update combobox values that way. The Column property is read-only.

 

[hermie]

Hi Douglas

Mmm I thought it was posible, but is there another way to do this?

Herman

 

[Douglas J. Steele]

Presumably your combobox is based on data in a table. Update the table row,
and do a requery on your combobox.