Subject Re: requery problem (semi reason) From Mervyn Bick <invalid@invalid.invalid> Date Wed, 22 Jul 2020 08:12:55 +0200 Newsgroups dbase.getting-started On 2020-07-21 22:58, Heinz Kesting wrote: > Hi Mervyn > >> ***** Start ****** >> function PUSHBUTTON1_onClick() >>     // Print Batch Report for Batcher >> >>     LOCAL FormName,BatchSize >> >>    ingnum = 0 //what is this for? >>    // Set up printer for report on Batch Ingredients >>    form.batch1.rowset.first() >> >>    if form.batch1.rowset.first() >>       msgbox('No records to print in batch.dbf','Warning',64) >>    else >>       choosePrinter() > > Sorry to disturb again, but if we do it this way Tony will save a lot of > paper ... (gr) ... so I'd prefer it that way > AArgh! I'm really getting past it  :-(  That was meant to be    if NOT form.batch1.rowset.first()       msgbox('No records to print in batch.dbf','Warning',64)    else       choosePrinter()       _copies=2 With the 'not' the message box goes in the IF section and the code goes in the ELSE section.  Without the 'not' it's the other way round. Adding one word is going to be quicker than a cut & paste exercise. :-) Tony, please add that 'not' to my code (it's not case sensitive) before you test it otherwise, as Heinz has pointed out, you are going to waste paper (and receive an error into the bargain) if you try and print with an empty batch.dbf. > Kind regards, and a big smile! Heinz Thank you for picking up on my booboo. Mervyn.