Refresh List after edits

  • Thread starter Thread starter Isis
  • Start date Start date
I

Isis

I ahv a List, and a field that can be updated - how do I refresh the List
display after the user updates a field - VB if pos.

Thanks
 
Isis,
Private Sub SomeField_AfterUpdate()
lstYourList.Requery
End Sub
Click to expand...

Al,

Thanks for that - works perfectly. Is there a difference between this and
using 'Me.Refresh' ?

Also - I am allowing a user to edit one of the fields shown on the list,
but in a bound field undeneath it - this works fine - however I want to
validate his entry based on the values in some of the other fields in the
currently highlighted record - some of these are calculated. I want to do
something like;

FieldBeingEdited Validation Text = '<= (calculated)TotalSales -
(noncalculated)Returns

I hope that makes some sense !

Basicall the field being edited cannot contain an amount greater than a
calculated field in the List minus a non calculated filed in the List.

Any more help much appreciated.

Thanks
 
Back
Top