Report will not view - From number to text ?

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

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

Similar Threads

Blank Page at Odd-Numbered-Pages 3
Dlookup Help 5
Opening a Report to a Specific Record 5
Customer number - Long integer ? 2
Data Type mismatch in criteria expression - WHY?WHY?WHy? 4
Multiple Criteria in Where Clause 2
Pass x number of parameters to a report from a form 2
Need a form for Customer Range - can I copy the one I used for dat 1

Top