Recent content by christopherjoubert

I edited the original post to include the info you requested @theDBguy the values are passed in as a string, specifically the name of a report, ie rpt_Report1 and the filter "[FIELDNAME] LIKE " variable "... or some permutation of that.

I have the following code segment in a vba module for a specific form : Me.srpt_Report.SourceObject = Report Forms!frm_MainLanding!srpt_Report.Report.filter = Filter Forms!frm_MainLanding!srpt_Report.Report.FilterOn = True It works perfectly embedding and filtering the report, my issue is I...

I was finally able to get the reports to embed. I did this by creating a subreport control on the form, had to drag and drop a report then delete the SourceObject in order to give me an Unbound subreport, as otherwise it always defaulted to subform. It was giving me an issue, then I restarted...

@theDBguy & @The_Doc_Man I am using Access 2019. @isladogs the problem with using the drag method is it doesn't allow the endusers to change which report is showing, it will always show that one report.

I have found two necroposts about this subject dating back to 2004 What I Am wondering is it still possible, and how to go about as this method doesn't seem to function properly? What I have is an inventory control database, and the end users need to look up devices, etc. the previous...

Hi, I am the IT Manager at a small non-Profit in the US. My focus had been on Data Analysis, and when onboarded they gave me control of their Databases, which had been designed by a third party. I had worked with Access during college in the early 2000's but was rusty. Nothing like sharpening up.