I have a form with 2 text boxes linked to a table (table1). One is a drop
down box (DB1)to select user and one is text box (T1)to enter Department.
table1 has 2 fields: Name and Dept. I would like the department to be
entered based the name selected.
table1:
Expand|Select|Wrap|Line Numbers
- Name Dept
- Ish NB
- John BC
- Bob NB
box (T1)should show NB..If I select John then BC show..etc
Right now I am doing the following:
Expand|Select|Wrap|Line Numbers
- Private Sub DB1_AfterUpdate()
- If Me.DB1 = "Ish" Or Me.DB1 = "Bob" Then
- Me.T1= "NB"
- Else
- Me.T1 = "BC"
- End If