ms access - Form transition and data refresh -
i have form button , when push it, opens form. when close second form need refresh first form.
so need insert first form name in global variable access form name second form refresh first form.
i tried create this:
global formname form formname = activeform.name
but receive error saying: option read only.
on click
event of button can pass name of form openargs
property of docmd.openform
.
private sub command4_click() docmd.openform "frmstaff", , , , , , me.name end sub
on close
event of second form can check (string) value:
private sub form_close() if me.openargs <> "" 'msgbox me.openargs forms(me.openargs).refresh 'or .requery end if end sub
Comments
Post a Comment