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.
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.