How to call Form_Load of one form from another form in Access VBA -
i have ms access form displays list of records in grid . each row having detail buttton.
when clicked on , opens new form details of particular selected row.
when click on close button of detail form , the values saved database.
now , on click of close , to execute form load of main form . because need refresh values after update made in detail form
i have tried thing :
call forms!frm_package!form_load
please suggest on how accomplish . have tried various ways not worked.
please let me know if further information required.
the reason not "re-call
" load because private sub
, when inside form can access method.
one way hack "external procedure call" move code inside form load public sub (withing same form) , calling newly created sub outside form. like,
private sub form_load() msgbox "hello world" end sub
to
private sub form_load() newpubmethod end sub public sub newpubmethod() msgbox "hello world" end sub
now able call public sub newpubmethod outside form right quantifiers.
private sub exitbuttonname_click() forms("callingformname").newpubmethod end sub
Comments
Post a Comment