Search For Record

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top