Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Hi, I have this (sub)form with a
dj As an alternative solution to your first problem, you could have created a 'not in' query which showed the list of products that do not have a corresponding value in your order list table. Re: your second problem, you could disable your 'amount' box and enable it in the lostfocus or...- freyni
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Report Where condition in variable doesn't do anything
Thanks for the help. I checked the datatype and it is a string. I've used the debug window to monitor the value of the variable. I've even pasted the result into my code to replace the variable - and it works. It just doesn't work with the variable- freyni
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Report Where condition in variable doesn't do anything
In my code, I build a where condition to be used in conjunction with docmd.openreport and I assign it to a variable vReportCondition. vReportCondition = "[Sample_Stream] = 'AQU'" When I run the following: Docmd.OpenReport vReportName, acViewPreview,,vReportCondition the variable...- freyni
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
