ADO Requery disables text boxes 
Author Message
 ADO Requery disables text boxes

Using VB 6 Professional, and ADO 2.0.

Have a command object (read only, client-side, static), based on a SQL
statement involving a simple join of 2 tables.

The form has some text boxes bound to fields of the result set, and
command buttons to go to next and previous records of the result set.

Prior to doing a requery everything works fine.  If I do a requery, the
text boxes are frozen on the record prior to the requery.  The command
buttons still work, however.  I can tell the command buttons still work
by BOF and EOF beeps, and by checking the AbsolutePosition Property in
debug mode.

Additional info:

In debug, I verified that the text box properties DataField and
DataMember were preserved after the requery.  For some reason, I got an
error when trying to see the DataSource property (either before or after

I tried Resync as an alternative, but the Resync with no parameters
gives error "insufficient base table information for updating or
refreshing", and putting in parameters gives compile errors.

Appreciate any help:

Especially on text box freezing
Problem seeing DataSource when Printing in immediate window,
Resync issues

Thanks very much,

John Fields

Mon, 25 Feb 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. ADO Requery disables text boxes

2. Requery text box

3. Selecting text in disabled text boxes...

4. Dim text in disabled text boxes

5. dark text in disabled text box

6. Text in disabled text boxes

7. Dimmed text in disabled text box

8. Text Box Disable text

9. ADO List box and Text boxes

10. Text box text on new page text box

11. Problems Disabling/Enabling Unbound Text Boxes

12. HowTo disable text box validation


Powered by phpBB® Forum Software