y won't button open?

[yessir]

my button is supposed to open a report

this is the code

Private Sub Command42_Click()
On Error GoTo Err_Command42_Click

DoCmd.OpenReport "rptAIDSWalkerPledges", acViewPreview

Exit_Command42_Click:
Exit Sub

Err_Command42_Click:
MsgBox Err.Description
Resume Exit_Command42_Click

End Sub


y won't it?

 

[Mile-O]

Well, let's look at it from the other side...what does it do?

 

[yessir]

just open

i just want the button to open the form as it is...


it's based off the query called

qryAIDSWalkerPledges

 

[Mile-O]

I know but I'm asking "Does anything happen just now with the code?"

Are you getting an error message?

Check the button's properties?
Is its Click() event set to [Event Procedure]?
Set breakpoints on the code. Are you taken through the steps?

 

[namliam]

Open a FORM or a REPORT ???

 

[yessir]

sorry

notta!

the report doesn't open,

no error given

just click and notta

 

[yessir]

report

open a report from a button on a form

 

[namliam]

No data?
Hidden?

 

[Mile-O]

Did you try using breakpoints as I suggested?

 

[yessir]

here;s the DB

DB

 

[Mile-O]

I use Access '97.

 

[yessir]

i can;t

i can't make it access 97

 

[Mile-O]

Why not?

I can't remember exactly what menu it comes under but you have the option to Save as Previous Version ---> Access '97 Format

 

[yessir]

k

k

 

[Mile-O]

Is its Click() event set to [Event Procedure]?

It's as I asked earlier on.


Open the command button's properties and put [Event Procedure] in the Click event.

 

[yessir]

thanks

thanks

 

[coryt]

Look under the properties of the button. Click on the "Event" tab. Click the drop down box next tho the "On Click" event and choose "Event Procedure". This will fix your problem.