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

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
 
A

Abbas

Correction: When I use the debugger, clicking on a txtA cell on the datasheet
part, 'Intermittently', updates txtB!
 
A

Abbas

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Afterupdate problem with setfocus on a txtbox in a form 2
Unable to hide/show controls by clicking on datasheet of split for 0
Hide columns in the datasheet part of a split form 4
Enforcing a unique "business ID" 11
Select multiple records in the datasheet part of split form. 0
Problems with onClick Event 0
Setting the OnClick property of a control on a code-created form 3
OnClick Event in Datasheet 1

Top