VB 6 Data Enviornment - HELP!!!

[ALieN EgO]

Okay, my problem is this: I am using the data environment as my connection to an Access database. I have created a VIEW command to link up 3 tables and have databound controls on a form using this command. No problems there. I have a field that the user can change, but in order to effect the change, I have used another command to update the relevant table using parameters.
PROBLEM: Whenever the change is effected, the form holding the data loses it's data connection, so you can no longer move between records and the changes are not displayed in the databound controls.
When you reload the app, the changes have been made, and the form can navigat ethe recordset again.

HOW DO I UPDATE THE FIELD WITHOUT CHANGING THE VALUE OF THE CONTROL (A CAPTION, NOIT A TEXT BOX)?

Thanks in advance.

ALieN EgO

[Ecniv]

Originally posted by ALieN EgO
... I have used another command to update the relevant table using parameters.

PROBLEM: Whenever the change is effected, the form holding the data loses it's data connection, so you can no longer move between records and the changes are not displayed in the databound controls.

I suggest you look at the command parameters - if you close the connection (by accident) it could and probably does affect the controls also using that connection.

As to data enviroment - well good luck


Vince

[Jackalx25]

You may have to rebind the control to the DE ie.

Set yourcontrol.datasouce = de

cheers

jack