Jumat, 17 Juli 2020

Re: [MSAccessProfessionals] Access report, need to pass parameters to SQL Server back end

Thanks, Crystal!  Actually, I just realized the parameter selection form is used by multiple reports, so I can't change the query and open report from the click of OK button on the form.  I guess I need to do it in the report.  The report's open event currently have a macro to open the parameter selection form, which is needed.  Now where should I put the code of changing query according to the parameter selection? "load" event?  Thanks very much!
_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115702) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Tidak ada komentar:

Posting Komentar