J
James
Hello,
I have a form and subform. In a nutshell: the form displays total
registration information and the subform displays details about the
registration. The subform records have 4 fields that are added together to
give a total for that record and the sum of the subform records is the total
amount of registration fees accounted for. The main form displays information
about the total of fees accounted for (basically the total of all fields and
records in the subform list) and displays the amount yet to be accounted for
(the difference between the amount accounted for and the actual total
registration fee due). Obviously, to pull this off I have to do some
recalculating after any amount field in the subform is changed. All of this
is fairly straightforward. The only problem I have is that if I actually do a
RECALC in the AfterUpdate then no matter what key I used to exit that field
with the keystroke is "gobbled up" and the cursor remains in that field. I
would like it to behave something like a spreadsheet so that the cursor moves
as a user would expect - not require TWO tabs (for example) to move to the
next field. I have tried any number of configurations using onenter, onexit,
etc. and cannot seem to overcome this "feature". Even more baffling is that I
have another example with a different form that works but I can see NO
difference between what I am doing in the one than in the other. (This is
happening in A2K sp3). I think I am doing something really stupid but can't
seem to figure it out. Any suggestions would be appreciated. I'm happy to
post the code if it will help.
I have a form and subform. In a nutshell: the form displays total
registration information and the subform displays details about the
registration. The subform records have 4 fields that are added together to
give a total for that record and the sum of the subform records is the total
amount of registration fees accounted for. The main form displays information
about the total of fees accounted for (basically the total of all fields and
records in the subform list) and displays the amount yet to be accounted for
(the difference between the amount accounted for and the actual total
registration fee due). Obviously, to pull this off I have to do some
recalculating after any amount field in the subform is changed. All of this
is fairly straightforward. The only problem I have is that if I actually do a
RECALC in the AfterUpdate then no matter what key I used to exit that field
with the keystroke is "gobbled up" and the cursor remains in that field. I
would like it to behave something like a spreadsheet so that the cursor moves
as a user would expect - not require TWO tabs (for example) to move to the
next field. I have tried any number of configurations using onenter, onexit,
etc. and cannot seem to overcome this "feature". Even more baffling is that I
have another example with a different form that works but I can see NO
difference between what I am doing in the one than in the other. (This is
happening in A2K sp3). I think I am doing something really stupid but can't
seem to figure it out. Any suggestions would be appreciated. I'm happy to
post the code if it will help.