Problem with the OnClick event of the datasheet part of a split foThis is a discussion on Problem with the OnClick event of the datasheet part of a split fo within the ADO DAO RDO RDS forums in Framework and Interface Programming category; 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... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
09-08-2008, 05:40 AM
| |||
| |||
 Problem with the OnClick event of the datasheet part of a split fo 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  |
|
#2
09-08-2008, 06:03 AM
| |||
| |||
| RE: Problem with the OnClick event of the datasheet part of a split fo Correction: When I use the debugger, clicking on a txtA cell on the datasheet part, 'Intermittently', updates txtB! "Abbas" wrote: > 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 > |
|
#3
09-08-2008, 06:42 AM
| |||
| |||
| RE: Problem with the OnClick event of the datasheet part of a spli 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 "Abbas" wrote: > Correction: When I use the debugger, clicking on a txtA cell on the datasheet > part, 'Intermittently', updates txtB! > > "Abbas" wrote: > > > 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 > > |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 01:33 PM.
