help in report viewing

[Guest]

i made a dbase for students,what i want to do is that every changes i made in
the form will be automatically displayed when i click the report preview
button..what coding should i do?..thanks

 

[Stefan Hoffmann]

hi Renato,

i made a dbase for students,what i want to do is that every changes i made in
the form will be automatically displayed when i click the report preview
button..what coding should i do?..thanks

You need to save the changes before viewing your report. If you are
using a macro, switch to an event procedure like that:

Private Sub cmdShowReport_Click()

On Local Error Goto LocalError

If Dirty Then Dirty = False

DoCmd.OpenReport "YourReport", acViewPreview

Exit Sub

LocalError:
MsgBox Err.Description

End Sub


mfG
--> stefan <--

 

[Susie DBA [MSFT]]

use SQL Server and triggers