Set field value on after update event of combo box

[sophannaly]

Hi,
I have a point that I don't know how to do it. My form is bounced to a table but not all fields of table have on form. There is a combo box which retrieve three column value. On combo box after update event, I want to use its column count(2) assign to a table field that doesn't have control on form.

Could anybody tell me how to do this

Sophanna

[jimatqsi]

sophannaly,
If I understand your question right, you want to code something like this:

me.some_field_on_the_form=me.combobox.Column(2)

some_field_on_the_form refers to the field you are trying to update
and combobox refers to the name of the combobox with the 3 columns. The first column of a combobox is Column(0), the 3rd column is Column(2)

Jim

[sophannaly]

Hi Jim,

Thanks for your reply. But my problem is I would like to send combo box column(2) to a field in table which I didn't assign any textbox or combo box on form. For example, my table fields are a, b, c, d. On form, I have assign combo box which bound to field a, text field for b and c. After combo box A is selected, I would like to use after update even on combo box and send it column(2) value to field d. And this form is bound to that table.

Could you tell me how could I archive this?

Sophana

[twinnyfo]

Sophanally,

I have to say that I am thoroughly confused. If you have a table with fields a, b, c and d, I don't understand how the combo box is bound to field a, but also fields b and c?!?!?!

Then, field d is somehow to be updated based on the combo box? It doesn't seem like you are accomplishing anything, other than making field d equal to one of the other fields. Please explain a little better, because I'm not sure this makes any sense otherwise.

[jimatqsi]

So, obviously one choice would be to put field d on the form, bound to a textbox or combobox. Then in the original combobox after_update event you could set the value of the new object to that combobox value. But then, why not just update the new object directly? What's the point of having this original combobox.

Oh, you did say the original combobox is already bound to a field. You can't bind it to two fields, so yes, the after_update event is the way to go.

You can hide the field d object; just set the Visible property to no. That way it will be on the form, bound to some new textbox that can't be seen, and you can easily update it with a simple

me.fieldD_txt = me.OriginalComboBox
 

Something like that, just use the object names that you use on your form.

Jim

[sophannaly]

Hi Jim,

Thanks you so much for your idea and it helps.

Sophanna

[NeoPa]

@Sophana.
If you already have a field that you can use to determine the value you want stored - then you should not be thinking about storing that value too. This is un-normalised data - and that's a bad thing in relational databases. See Database Normalisation and Table Structures for more on that.

[sophannaly]

Hi NeoPa,

Thanks for your idea. The table that I do data entry, there is a foreign key reference to table that has two fields (code+level) combine together as PK. So in reference table, we also need to use these two fields as foreign key. On data entry form, I just let user choose only code from drop down list (dropdown list display data: code, level, description). After user choosing code, then I will store level automatically (each code refer to only one level, and there are some codes that has duplicate value but it is in different level, so I need to combine these two fields together as PK).

Sophanna