Help with button macro

[lorenambrose]

I have a button set up using the button wizzard that opens another form of the same record. So if you are on form A record 8 and hit the button it opens form B record 8.

This is the condition that access 2007 has:


Code:


="[PNCR Number]=" & [PNCR #]
Problem is that if someone hits the button when form A says record "(NEW)" you get a syntax error.

Is there a way to have the macro look at the record # [PNCR Number] and only work if the field is 1 or higher

[alansidman]

Cross Post
Solution at http://www.mrexcel.com/forum/showthread.php?t=529268

Please read this http://www.excelguru.ca/node/7