Grrr why is this wrong?

[Madmax2]

Docmd.openform ("istatus",,,"[item#]='"&[item#]&"'"





it keeps compiling wrong for some reason. Just trying to open a status change sheet after checking a broke item in for people to write whats wrong with it...item# is on both forms and attached to the same table...thoughts?

[Bob Fitz]

What is the data type of item. If it is numeric then the single quotes are not needed.
Also, you should not use special characters "#" when naming objects.

[Madmax2]

Aye its numerical. /sighs. Its been two years so my naming conventions were a little off...luckly i am building it as a tool checkout program and nothing in it is very intensive but if i manage a new job elsewhere i will stay away from the number sign next time.

[Madmax2]

Still missing with the single quotes removed. The compile error is expected:=

[Bob Fitz]

I think you may need to change that Field Name

[ItsMe]

I think you may need to change that Field Name

That is what I am thinking

[pbaldy]

You have a stray parentheses. Try

Docmd.openform "istatus",,,"[item#]=" & [item#]

[Madmax2]

Bingo! Thanks paul

[pbaldy]

Happy to help!