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

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

Does Firefox offer AppleScript support to get URL of windows? -

android - How to install packaged app on Firefox for mobile? -