G
Guest
2003 ADP – SQL Server 200
I have a datasheet subform that has a stored procedure as the recordset.
Because the sp has to select on multiple tables for description purposes I
have set the Unique Table and Resysnc properties.
As soon as I change a single character in the datasheet (e.g. field name
Quantity which is bound to that UniqueTable ) the field AfterUpdate event
fires followed immediately by the form’s BeforeUpdate Event and so on. Again
I have only changed a single character! I haven’t even tabbed out of the
field or clicked elsewhere.
Other strange things occur beyond there but I will start with this odd
behavior!
What would cause these events to fire on a single keystroke? The subform
KeyPreview property is set to no. As is the main form.
I have checked the Link Master and the Linked child fields and all seems
good there.
Any ideas? Thanks for your help!
I have a datasheet subform that has a stored procedure as the recordset.
Because the sp has to select on multiple tables for description purposes I
have set the Unique Table and Resysnc properties.
As soon as I change a single character in the datasheet (e.g. field name
Quantity which is bound to that UniqueTable ) the field AfterUpdate event
fires followed immediately by the form’s BeforeUpdate Event and so on. Again
I have only changed a single character! I haven’t even tabbed out of the
field or clicked elsewhere.
Other strange things occur beyond there but I will start with this odd
behavior!
What would cause these events to fire on a single keystroke? The subform
KeyPreview property is set to no. As is the main form.
I have checked the Link Master and the Linked child fields and all seems
good there.
Any ideas? Thanks for your help!