Don't Print if no data...question??

[WB786]

I have a report that will list certain info and if one of the field(s) on the database is not filled in then I don't want this report to print and instead put up a message saying "Can not print. Account number missing!!"

The user will be pressing a button to view/print the report and the report is based on a query which will pull certain fields from the table.

On any given record you can have more than one accounts for a single record or customer.

Let me know if you need more info.

Thanks in advance,
WB

 

[WildHare]

In your button_Click event:

if IsNull(Me.AccountNumber) then
Msgbox "Sorry - you must enter an account number for this report to print. Please try again"
DoCmd.CancelEvent
Exit Sub
end IF

..and then continue on

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[WB786]

Would that work if the table is linked to the main table that stores just account info and customer info in the main table?

WB

 

[WildHare]

Yes - you're just checking for the existence of an account number on the form's text box, which I assume, from your posting, is just an unbound text control.

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm