link between text boxes

  • Thread starter Thread starter Loi Tran
  • Start date Start date
L

Loi Tran

Hi,
I created a data entry form which has two fields.
For example, [Code Number] and [level Number]. I think
that it is convenience if they are link.

I wish that if I enter 999 in [Code Number], the letter 1
will automatically appear in [Level Number].

999-----1
100-----2
110-----3 and so on

Thank you
Loi Tran
 
Place code along the following lines in the [CodeNumber]
AfterUpdate event handler

Select Case [CodeNumber]
Case 999
[Level Number] = 1
Case 100
[Level Number] = 2
Case 101
[Level Number] = 3
etc
End Select

Hope This Helps
Gerald Stanley MCSD
 
Back
Top