- Joined
- Jul 12, 2011
- Messages
- 7
- Reaction score
- 0
Hello,
I'm in the (not) fun process of having to change the data type of our PK to accommodate new requirements set by our clients. So far the switch has been surprisingly painless, except for my current problem.
Basics: Running Access 2007 Front End, SQL 2008 R2 Backend.
I have an unbound text box with its Row Source set to a SQL statement that queries the necessary info, and it works beautifully. However, since we have switch data types of our PK from numeric to varchar the macro (below) no longer works.
Action Arguments
SearchForRecord ,,First,=[TS] =" & Str(Nz([Screen].[ActiveControl],0))
Any one know why and how I can fix this? This has brought my office to a near stand still!!!
Please Help Me!!!!
David92595
I'm in the (not) fun process of having to change the data type of our PK to accommodate new requirements set by our clients. So far the switch has been surprisingly painless, except for my current problem.
Basics: Running Access 2007 Front End, SQL 2008 R2 Backend.
I have an unbound text box with its Row Source set to a SQL statement that queries the necessary info, and it works beautifully. However, since we have switch data types of our PK from numeric to varchar the macro (below) no longer works.
Action Arguments
SearchForRecord ,,First,=[TS] =" & Str(Nz([Screen].[ActiveControl],0))
Any one know why and how I can fix this? This has brought my office to a near stand still!!!
Please Help Me!!!!
David92595