Forms Help

[dancat]

Hi there i have been using this forum and have found it very useful, thanks to all who contribute here.

My latest problem i am facing is i was wondering is there was a way that if and option is selected from field1 which is a list box can the next field be automatically updated with txt to describe the choice made in field 1, (may need to be a memo field)

Thanks in advance

 

[ezfriend]

Private Sub Form_Load()
    'lstField Row Source Type = Value List
    lstField.AddItem "001"
    lstField.AddItem "002"
    lstField.AddItem "003"
    lstField.AddItem "004"
    lstField.AddItem "005"
    
End Sub

Private Sub lstField_Click()
    Text2 = lstField.ItemData(lstField.ListIndex)
End Sub

 

[dancat]

Thanks i will give it a try today