N
New ADP Kid on Block
Access 2000 ADP - Windows 2000 Pro - SQL Server 2000
Working on an ADP written by someone else, who decided to
use popup Input Boxes in the click event of each Text Box
Control to edit/update. And, each field updated in this
way causes an UPDATE SQL to be executed to update the
record in the database.
I eliminated the call to the UpdateRoutine that pops up
the Input Box, and checked that all the TextBoxes have
Enabled = Yes, Locked = No, and that the Form properties
Allow Edit, Add, and Delete. Yet when I place the cursor
in one of the Text Boxes, it indicates it is there but I
can't highlight text nor change it, nor add any new text.
(I verified the settings at runtime, too, and they are
still as described.)
The SQL Statement used in the Form's RecordSource has
several LEFT JOINs, so may not be updateable. Is this the
behavior expected if the Form's RecordSource is SQL that
is not updateable?
Working on an ADP written by someone else, who decided to
use popup Input Boxes in the click event of each Text Box
Control to edit/update. And, each field updated in this
way causes an UPDATE SQL to be executed to update the
record in the database.
I eliminated the call to the UpdateRoutine that pops up
the Input Box, and checked that all the TextBoxes have
Enabled = Yes, Locked = No, and that the Form properties
Allow Edit, Add, and Delete. Yet when I place the cursor
in one of the Text Boxes, it indicates it is there but I
can't highlight text nor change it, nor add any new text.
(I verified the settings at runtime, too, and they are
still as described.)
The SQL Statement used in the Form's RecordSource has
several LEFT JOINs, so may not be updateable. Is this the
behavior expected if the Form's RecordSource is SQL that
is not updateable?