one form field updates another

[Guest]

I need one field to update another but don't know how.

My User Directory table has two fields that are needed but directly
related...I know I should create a table just for them...that would take more
work, becasue I would have to change a bunch of other stuff and I'm working
around the user. It's a mess but it was worse when they gave it to me.

I have a form that updates the Directory table...I want to create a event
that will use Bldg Desc to update the Bldg Num. Can someone direct me to an
example of this?

Bldg Desc = Bldg Num
ASCN = 564
BCD = 530
BCA = 17

 

[Guest]

Ed,
Try use the Select Case.

For Example:

Select Case Me.BldgDesc
Case "ASCN"
Me.BldgNum = 564
Case "BCD"
Me.BldgNum = 530
Case "BCA"
Me.BldgNum = 17
End Select

HTH.

 

[John Vinson]

I need one field to update another but don't know how.

My User Directory table has two fields that are needed but directly
related...I know I should create a table just for them...that would take more
work, becasue I would have to change a bunch of other stuff and I'm working
around the user. It's a mess but it was worse when they gave it to me.

I have a form that updates the Directory table...I want to create a event
that will use Bldg Desc to update the Bldg Num. Can someone direct me to an
example of this?

Bldg Desc = Bldg Num
ASCN = 564
BCD = 530
BCA = 17

Under what circumstances do you want the Bldg Num to update? On new
entries? for existing records where Bldg Num is NULL? For existing
records where Bldg Num is wrong? How, given the existing data, can you
determine the proper Bldg Num value?

John W. Vinson[MVP]