Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RS does not update if DBCombo is only field changed

Status
Not open for further replies.

cyberbiker

Programmer
Mar 16, 2001
431
US
I have a form with various text boxes and a single DBcombo bound to a recordset.

If I update the recordset by modifying any of the data contained in any of the text boxes as well as the dbcombo box the recordset updates properly.

If I change the value in the dbcombo box without changing any other data the update fails.

When stepping through the code I reach the .update and never reach the WillChangeRecord event of the Recordset when only the DBCombo is changed.

What am I doing wrong with the DBCombo????



Terry (cyberbiker)
 
This is my work around
I added this line

adoPrimaryRS!assignedfield = DBFields.BoundText

immediately before

adoPrimaryRS.Update

still no idea why this is necessary when other datacombo controls on other forms work fine

Terry (cyberbiker)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top