Report generate based on another table value

[anissw]

Hi- I have a report with command buttons to export to PDF when pushed. However, I need to include script to read if data from another table exist with client ID that equals to client ID on the report, then a message box will instruct them they need to clear out data from table before proceeding to publish report and the report will close. Else proceed to publish. I don't know how to code to read a field value from a table to compare to my report. Is this possible?

Actually, now that I think about it, can I use DLOOKUP from the button on my report to lookup client ID? If so, is there a sample script I can test?

Thanks-

Anissw