Disabled Save Problem

[sandiclaus]

I have a Time Tracking Time Entry form used for data entry.
That form has a subform which shows all the time entries for that employee for that day. When the form loads, everything looks great. As soon as I try to navigate the subform (using record navigation or scroll bars) ALL the rows of data disapear!

I finally figured out (by process of elimination) what is causing the problem, but not how to fix it.

I have the following code in my BeforeUpdate event:
If bolSaveRecord = False Then
Me.Undo
Cancel = -1
End If

Removing the code solves the subform problem, but saves an incomplete record if you use any scroll bars on the subform.
I tried putting the code in the On Enter and/or On Exit events of my Subform but it disables my Close command button.

Can anyone help?!?

 

[Rolliee]

It sounds like vacuous (empty) records. Look at them in the table view or query view and see if that is not the case.

rollie@bwsys.net