Search results

I appreciate your help, I agree my naming convention needs work. However, I am unable to pass the variable to the report with this setup. If filters nothing.

I have a report with 2 option groups, I cannot get both of them to filter the data simataneously, they will each inititally filter the data, but when the opposite group it clicked, the previous filter data does not remain filtered. I have posted the code for the two option groups, I know I'm...

What I meant to say is I have a report that loads from a form with the control source of the report based on a parameter query, the report is loaded with Me.Filter based on the criteria chosen from the form. I want a command button on the report to load another form with a listbox to further...

I have a report based on a query, the report loads filter based on dates input to the query from Form1 when report loads. I want to filter this report further from a listbox on form2, but I want the listbox rowsource to populate based on a field in the loaded report. Is this possible?

Thank you, I was missing the fact that it could be used to replace the title of the message box. You jogged my memory. Once again thanks.

pbaldy, I figured it out, I posted the code for anyone to use. This allows you to create a command button and click it to see what is handing out there open in your database, it displays the name of what the open Accessobject is. Private Sub Command51_Click() Dim aob As AccessObject Dim obj...

No, compile error, invalid use of property. That is what is confusing me. I thought that property could be used in that context.

I have the follow code tha tells me when an object is laoded, I cannot get it to display the name of the form or report or whatever object isloaded. any help would be appreciated. Private Sub Command51_Click() Dim aob As AccessObject Dim obj As AccessObject With CurrentData ' "Tables" For...