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

Popular posts from this blog

javascript - jQuery: Add class depending on URL in the best way -

caching - How to check if a url path exists in the service worker cache -

Redirect to a HTTPS version using .htaccess -