DSum()

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

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
 
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
 
Thanks, Tina.

tina said:
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
Click to expand...
 
Back
Top