Access 2010 Data Macros Causing Form Refresh For No Reason -

i'd report bug microsoft, wondering if else has encountered this.

++++

here's interesting , obscure issue access 2010 data macros.

the issue firing of before update data macro on table causing unwanted , unnecessary form refresh. refresh clearing selections several multi-select listboxes on th form. want selections stay. form worked wanted prior adding data macro (no clearing of mslb selections).

to reproduce issue.

this happening in split / front end - end scenario. front , both being access 2010 files.

in end accdb... create table "items" id , description columns , date_updated column. put data macro on before update on table sets "date_updated" field now().

in front end accdb... items table linked...

now create blank form unbound table. create unbound multi select listbox on form , populate via other table or value list (doesn't matter rowsource is) , can bound or unbound - doesn't matter.

• now notice if run form, select items in listbox press f5 ("refresh"), listbox selections cleared expected. demonstrate refresh of form clears listbox selections. *

now create button on form. behind button, put vba code this.

docmd.runsql "insert items (description) values ('test')" (just valid sql statement inserts row items table)

open form.

select several items in list box.

press button. see form refreshed , therefore lose listbox selections.

close form , remove data macro items table.

open form, select items in listbox, press button.

now there no data macro, form not refreshed , selections stay.

++++++++++++++++++

bottom line: reason data macro firing on table totally unrelated form (but triggered code behind form) causes form refresh.

disable data macro , form not refresh.

why data macro... on end accdb file... cause form refresh on front end? remember, form has nothing table, or data macro.

this forcing me abandon data macros. don't think intended or desired behavior in access 2010.

i'd love confirmation issue!

thanks!

i able confirm issue when before change data macro in place , list box multi select setting extended. under same conditions list box selections not clobbered if multi select setting simple. (i noticed when multi select set simple [f5] not clear selections either.)