Access Default Value from Other Field

[Mattitude]

Hello,

In access I want it so when someone enters a value in column1 the default value in column2 is automatically populated

Column1 Column2 (Default value)
A-----------1
B-----------2
C-----------3

A = 1
B = 2
C = 3

How and where would I express this?

 

[Mattitude]

Hello,

Using Microsoft Office 2010

I am working on one table.

Basically if someone selects a combo value in say column1 then the next column along column2 is automatically filled with a value corresponding to the value selected.

I dont want to involve excel as i know you can do this in access somehow.

Now the only ways i can think of doing this is through an expression in the default value property.

If [column1] = "A" then 1 If "B" then 2 or If "C" then 3

if that makes sense...