Well for some reason the syntax you gave me in your very first post is now working
strWhere = "[Record ID] = " & Me.Record_ID
Must have been user error [neutral] at some point while testing it.
Thanks for the solution and sorry for added confusion
Hey Ginger , sorry to be confusing. When I was saying filter, I mean't the Where clause. Basically from reading the OpenReport action parameters. It seemed to me the where clause is an additonal filter to your existing filter on the table/query that the report is created from. Which would work...
Ok, after figuring out how some of the syntax for this language works. I have found that the problem is in the filter for the report.
For instance
My primary key is a control named record_id
and the filter
"[record_id] = " & Me.record_id
is not working for me. Your "if" statement is working...
Thanks for the help Ginger & Hymn!
I am trying Ginger's method first, but I am getting stopped in the debugger on the line that has me.company
what does "me.Company" reference in your example? The field with the value I am comparing in the current record? the form name?
Well I tried changing...
Was wondering if anyone can point me in the right direction. I know very basic C++ programming, not familiar with VBA at all.
I am trying to make a command button in a form. That will print that form’s current selected record information in the format of a report I have already created. I also...
Was wondering if anyone can point me in the right direction. I know very basic C++ programming, not familiar with VBA at all.
I am trying to make a command button in a form. That will print that form’s current selected record information in the format of a report I have already created. I also...
Anyone know of a place where NRU 2.0 can be downloaded? Supposeably this is the only version that will work with a 616 using a RAD? Anyone know if that is correct also? Someone changed the default config password and need to reset it back to default. Was told it can be done via a RAD.
Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.