Problem with the OnClick event of the datasheet part of a split fo

  • Thread starter Thread starter Abbas
  • Start date Start date
A

Abbas

Hello!
I have a strange problem!
I have created a split form (Access 2007) with two text boxes (say txtA
(bound), and txtB (unbound)). Using the OnClick Event, I try to update txtB
from txtA. It works perfectly if I click txtA on the Form body; but not when
I click a txtA cell on the datasheet part; however, when I use the debugger
and step through the VBA code, both clicks work and txtB gets updated.
Any ideas?
Abbas
 
Correction: When I use the debugger, clicking on a txtA cell on the datasheet
part, 'Intermittently', updates txtB!
 
Hello!
I found out why using the debugger, intermittently updates txtB!! Actually,
when I use full screen debugger and switch between VB and Form windows, txtB
gets updated but when i have split windows, it doesn't. So, this suggests
that the process requires refreshing the Form; i added Me.Refresh and it
worked!!

Abbas
 
Back
Top