DSum()

[Guest]

I have several controls in a form which uses DSums to display the information
like total no of courses and credit hours based on information on a listbox.
The problem is that when I want to add a new record, the previous information
displayed in these controls remained on the form. How do I "blank" them and
then later make them use the DSum for display again? Thanks.
ck

 

[tina]

one solution might be to simply hide them when you're in a new record, by
adding code to the form's current event, as

With Me
.NameOfTotalCoursesControl.Visible = Not .NewRecord
.NameOfCreditHourseControl.Visible = Not .NewRecord
End With

hth

 

[Guest]

Thanks, Tina.

one solution might be to simply hide them when you're in a new record, by
adding code to the form's current event, as

With Me
.NameOfTotalCoursesControl.Visible = Not .NewRecord
.NameOfCreditHourseControl.Visible = Not .NewRecord
End With

hth