Needing help with macro code.

[sljensen]

I am trying to get a form to open like the one in the Students Sample Database in the education folder under sample templates where it opens a form through an "open" feature on the datasheet. The way they have it here is based on the Autonumber ID but I want to get it to open based on a code such as "SPGR2-U30-2007." I can't seem to figure out the right code. In the embedded macro under the Open Form Action Where Condition they have ="[ID]=" & Nz([ID],0) that allows you to select the record based on specific ID. What do I need to change here to make it work for a string? Or do I need to do something else with the code?

 

[vbaInet]

Have a look at this from pbaldy:

http://baldyweb.com/wherecondition.htm

 

[sljensen]

Thanks it worked like a charm!

 

[vbaInet]

No problem.