andy_dyer
Registered User.
- Local time
- Today, 02:02
- Joined
- Jul 2, 2003
- Messages
- 806
Hi,
I've seen a few posts around this subject but none seem to hit the spot I need..
I've seen pbaldy's link;
http://www.baldyweb.com/wherecondition.htm
And I'm trying to use it BUT...
I need to pass two parameters in...
Using the above link my code is
But I get the following error;
Run-time error '3075':
Syntax error in string in query expression 'txtYear = 2011".
I'm not sure if that's because I need to pass into the equation the ProjectID as well as the Year in roder to open the correct form?
Any ideas what I've done wrong?
Many thanks
I've seen a few posts around this subject but none seem to hit the spot I need..
I've seen pbaldy's link;
http://www.baldyweb.com/wherecondition.htm
And I'm trying to use it BUT...
I need to pass two parameters in...
Using the above link my code is
Code:
DoCmd.OpenForm "frmProjectFinanceYearDetail", , , "txtYear = " & Me.Year & "'"
But I get the following error;
Run-time error '3075':
Syntax error in string in query expression 'txtYear = 2011".
I'm not sure if that's because I need to pass into the equation the ProjectID as well as the Year in roder to open the correct form?
Any ideas what I've done wrong?
Many thanks