Report and Macro

J

Jose Aleman

Hello,

I have a report on a form that is being run by a macro. On the WHERE
CONDITION for the macro is the following statement:
[LoanNumber]=[Forms]![frmBorrowers]![LoanNumber]

When the user clicks on the button for the report to run, some of my
information does not appear. For Example:

I have a REQUEST (Memo field) where the user types his/her request. After
typing their request, they have to click to the next record and comeback in
order for the information to appear on the report.

Does anyone have any advice on what I can do?
 
G

Gina

Jose,
try creating a query with your [Forms]![frmBorrowers]![LoanNumber] as
criteria in column [LoanNumber]
run it ... and compare results of report to it .... thats where I would
start

Gina
 
Top