Is it possible that the control source of a textbox is from a query or report?
ex. in my expenses form i'll put a textbox then the control source is
=[rptBudget].[txtPastor]
I tried that one but still it's not working..
By the way my budget report is full textboxes and the control source are all expressions.
ex. the textbox for pastor budget [txtOperation]*.40
You shouldn't really be pulling data from a report because it's main purpose is for displaying data. If you open a report in Print Preview the record you will only be retrieving the last record printed and in Report View mode you will have to refresh the form everytime you move the cursor.
So you should either use a subform to get the value or use a DLookup() function:
