M
Mike DFR
My database worked fine with Access version 2002
My company has updated to 2003 version.
With the new version the subform datasheet is contiuously updating.
It give the appearance of flashing or scrolling, and does not update the
relevant list box.
For the search I am using;-
sub Combo#_AfterUpdate()
Me.ReordsetClone.FindFirst "['tablename']= '" & Me! [Combo#] & " ' "
Me.Bookmark = Me.ReordsetClone.Bookmark
Me.List6.RowSource = "SELECT DISTINCT ['table field etc etc........]
Then 'Me! [Combo#]= " " , to clear the combo boxes.
The subdatasheet uses an 'Iif' statment to show field 1 or field 2,
(depending which one is empty).
As I say all works well with Access 2002, but will not work in 2003.
My deadline for completion is end of month.
Can any body help please.
My company has updated to 2003 version.
With the new version the subform datasheet is contiuously updating.
It give the appearance of flashing or scrolling, and does not update the
relevant list box.
For the search I am using;-
sub Combo#_AfterUpdate()
Me.ReordsetClone.FindFirst "['tablename']= '" & Me! [Combo#] & " ' "
Me.Bookmark = Me.ReordsetClone.Bookmark
Me.List6.RowSource = "SELECT DISTINCT ['table field etc etc........]
Then 'Me! [Combo#]= " " , to clear the combo boxes.
The subdatasheet uses an 'Iif' statment to show field 1 or field 2,
(depending which one is empty).
As I say all works well with Access 2002, but will not work in 2003.
My deadline for completion is end of month.
Can any body help please.