Report will not view - From number to text ?

[SpookiePower]

I have a lot of customers in a tabel where the primary key
is the customernumber and the field is of the type number (Long integer).

My problem is that a customernumber can be up to 20 digit long,
so I thought that I should change the type from number to text, so
I did.

My problem is now that when I want to show a report for the
current customer using this code -

strWhere = "[Customernumber] = " & Me.[Customernumber]
DoCmd.OpenReport "raportArbejdsseddel", acViewPreview, , strWhere

I gets an error. I think that it might have something to
do with the change from number to text, but what can
I do to get it to work ??

 

[Duane Hookom]

strWhere = "[Customernumber] = """ & Me.[Customernumber] & """"

 

[SpookiePower]

strWhere = "[Customernumber] = """ & Me.[Customernumber] & """"

Thanks, it works.