How to assign values in combo box (1 Viewer)

[irslan rafique]

Hi,
I am new to access so please bear my question.
In a form, I have a combo box(combo1) that store values in field(remarks1) in a table.The values in combo box are:
SL
ST
DI
SL + ST
SL + DI
These all values are being saved in remarks1 quiet easily.
I have more fields in the table:
SL1
ST1
DT1
SLST1
SLDI1
I want when I selet SL from combo1 it saves SL in remarks1 and save "1" as well in SL1 field.I want to have same result with all five combo1 values
Please assist me.

 

[jdraw]

Lots of info re comboboxes

 

[Mihail]

Database Normalization and Table Structures - Microsoft Access / VBA