Report will not view - From number to text ?

  • Thread starter Thread starter SpookiePower
  • Start date Start date
S

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 ??
 
Back
Top