Error Msg.

C

capinvest

I am trying to set up a button that will look at the
current client record, find the clients ID number and then
print a client specific report. I have the following code
behind the button:

DoCmd.OpenReport "Situation", acViewPreview, , "[main].
[ID] = " & Me![ID]

I get the following error when I try to use the button:

Extra ) in query expression '([main].[ID] = )'.

Any help with this problem will be very appreciated.
Thanks.
 
C

capinvest

Thank you, that solved my problem. That is a huge weight
lifted off my shoulders. Thanks again.

-----Original Message-----
Try simply "[ID] = " & Me![ID]
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

capinvest said:
I am trying to set up a button that will look at the
current client record, find the clients ID number and then
print a client specific report. I have the following code
behind the button:

DoCmd.OpenReport "Situation", acViewPreview, , "[main].
[ID] = " & Me![ID]

I get the following error when I try to use the button:

Extra ) in query expression '([main].[ID] = )'.

Any help with this problem will be very appreciated.
Thanks.
Click to expand...


.
Click to expand...
 

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

Error outlook.com 0xc0000005 trying to open custom controls 0
Access 2010 DB not fuctional with multiple users 2
Syntax Error in query expression 7
Button Coding for Reports 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
access report 0
Using a query parameter for a report 4
Error Msg 1

Top