Report will not view - From number to text ?



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




Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question