Frank,
I completely recreated the report but got the same result after compiling it. The code is so simple and the same as I have for other reports on the same form. Assemblycost is the report name. The report works when in the explorer mode when using the WHERE builder. In the application it does not work. Below is the simple code I use. The same code is used on another report that works. SELECT (COUNT(*)) INTO vac2 INDICATOR ivac2 FROM assy_part + WHERE assembly# = .vpartnumid IF vac2 = 0 THEN PAUSE 1 USING 'Information not available. Use Assy_Part Entry Button!' + CAPTION 'Assembly Part Information' BUTTON 'Finish' GOTO done ELSE PRINT assemblycost WHERE assembly# = .vpartnumid + OPTION SCREEN|WINDOW_STATE MAXIMIZED + |ZOOM_TYPE PERCENTAGE|ZOOMPERCENT 100 ENDIF RECALC VAR LABEL done CLEAR VAR vac2, ivac2 SKIP TO partnum RETURN James Belisle Making Information Systems People Friendly Since 1990
