Missing Data

[JamesJ]

Hi. I'm using the following to print reports.

Function PrintReport(ByVal rptName As String)

DoCmd.Requery
DoCmd.OpenReport rptName, acNormal

End Function

When I call this function from a command button
on a form everything's fine. But, when I call the
same function from a custom toolbar new text doesn't get
printed. I must close and then re-open the form for the
new text to be printed.
Currently I'm using the RichText control to update a
grocery list. I believe this wouldn't make a difference wether
the control is a TextBox or a RichText. But if I should be
directing this problem to another newsgroup let me know.

 

[strive4peace]

Hi James,

not sure what you mean by "new text doesn't get
printed" ... is this a new record you are creating?

perhaps you need to save the record in order for it to be
available for the report

if me.dirty then me.dirty = false

or

if forms!formname.dirty then forms!formname.dirty = false
DoEvents

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com