Updating fields on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a form that allows users to update pupil data. I have a list box
[Cluster] where the user chooses from a locked set of values. If one
specific value is chosen I would like a seperate field [OOB School] to update
to true ( this is shown as a check box). I am very new to this and am unsure
as to the best way to appraoch this. Any help would be great

Thanks!
 
Hi, bamf.

This can be done through the list box' AfterUpdate event, which fires when
the value in the control changes.

If Me!YourListBox = YourSpecificValue Then
Me![OOB School] = True
End If

YourSpecificValue is the data in the BoundColumn of the list box. This
could be different from what is displayed depending on the ColumnWidths
property.

Sprinks
 
Back
Top