Can't type into control on ADP Form

  • Thread starter Thread starter New ADP Kid on Block
  • Start date Start date
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?
 
If the Form properties allow all kinds of edits, and the
control is not Locked and is Enabled (all checked at
runtime, just before trying to type into the control) ,
but Access won't allow you to highlight nor type into the
control, is that just the effect of an un-updateable
record source?

Thanks from New Kid.
 
Back
Top