Unanswered: Lost focus/Calculating... is breaking code
I am directing my users off a subform after a single entry is made. Most of my database is designed like this and keeps integrity in the data.
My s/f has 1 hidden control + 8 data controls - 4 are tab stops
Entering and tabbing through the controls is fast and easy, but when you tab out of the last control - it loses focus for a long time and shows calculating on the bottom left. When that stops you can click back in the last control and tab again, but then it's triggering If lngID = -2147483648# Then
MsgBox "Cannot find this Account!", vbCritical, "Help!"
and the m/f and s/f go blank
What I need to do is exit the s/f and save the data, then open a pop-up for the user to choose what they are going to do next.
How do I exit the s/f automatically saving the data and getting into my pop-up?
Why is the s/f calculating so long and losing focus?
Private Sub Form_Load()
Private Sub ACCOUNT_GotFocus()
DoCmd.OpenForm , acNormal, "UPDATECHOOSER3"