Field Update With VBA code

[sandya]

Items form:
ID - Brand --- Model --- Color --- Items Description
1 -- Samsung -1234 --- white ----Samsung 1234 white
2 -- Nokia -----225 ----black ----Nokia 225 black

Above Brand, Model, Color field's data is merged in Item Description field without entry & using with build formula =[Brand] & " " & [Model] & " " & [Color] so its working perfectly. But I need vba code for update the Item Description from Brand, Model and Color field's entry.

Can anyone help me how to give a vba code for this issue.

Thanks
Sandhya.

 

[Uncle Gizmo]

what condition(s) will trigger the update?

 

[spikepl]

You have not followed the advice given to you in your previous thread on the same topic, have you?

http://www.access-programmers.co.uk/forums/showthread.php?t=256499

 

[pradeepiyer]

You wont be able to update the description field "automatically". For that, you would have to declare the field as calculated field and provide the formula (as you mentioned).

To handle this through VB code, you need to have a triggering event and upon that, you can use this code:

Code:
Me.Description.Value = Me.Brand.Value & " " & Me.Model.Value & " " & Me.Color.Value

 

[sandya]

Yes its working perfectly below code thank you so much dear

Code:
Me.Description.Value = Me.Brand.Value & " " & Me.Model.Value & " " & Me.Color.Value

 

[Uncle Gizmo]

you would have to declare the field as calculated field

What do you mean?

 

[pradeepiyer]

What do you mean?

Sorry, I meant this....create the field with type "Calculated Field" and provide the formula in the expression.

 

[Uncle Gizmo]

Create the field with type "Calculated Field"

How do you do that?