vba - Text Box on form must pick up data from another form -
i have 2 forms: frmreceipts , frmdiffs. frmreceipts has unbound control shows result of function:
public function recdiffs() double recdiffs = forms!frmdiffs.text17 end function
at moment value of text17 54.00 when frmreceipts opens shows value 0.00 on control text41. can correct clicking command button runs me.form.refresh
refresh not work (i.e. text17 continues show 0.00) if refresh runs on load, on open, or on activate. seems work clicking command button. ideally i'd correct value show in text17 when form opens. also, if put frmreceipts design mode form view, text17 shows correct data.
use
.requery
instead of refresh.
Comments
Post a Comment