can someone tell me what I'm doing wrong

[charlee63]

I am using
DoCmd.OpenForm "Issues Data", acNormal, "", "Issue #=" & Me.[Issue #], , acNormal
to Double click on an issue number to bring up the data on that number.
But keep get a "Syntax Error in Date in the Query Expression 'Issue # - ISM1040109'." Error


Issue # is not a Date? It is a text field.

 

[Joe4]

The # symbol is used as Date Qualifiers in Access (i.e. #1/1/2016#). This is a good reason why you should never use symbols or special characters in names of objects, fields, or variables.
You could try:
"[Issue #]=" & Me.[Issue #]

though I would highly recommend changing the name of your field, if at all possible.

 

[charlee63]

Ok I change the field names DoCmd.OpenForm "Issues Data", , , "[Issue]=" & Me.[Issue] and now I get a box that Says "Enter Parameter Value" Twice one with the Header Issue and the other with ISM1040109

 

[Joe4]

It thinks it is a parameter query now, and is prompting you.
I think you may have to try changing that field name. It definitely violates good naming standards. You want to avoid using special characters or reserved words. It is also recommend to avoid using spaces (I recommend using underscores in place of spaces). If you keep it to numbers, letters, and underscores and avoid reserved words, you will be in good shape.