Refresh Report Data

[fabioltj]

I have one report based on my table and form (off course).

My problem is: when I add a new record in the database (via table or form), this new record does not show up in my report .... your "space" show up blank

What I need to do to refresh these records ? Or what's the problem

Thanks in advance
Fabio

 

[ttimkim]

no data shows on the report.

Hi,
I use the code "acCmdSaveAllRecords" in front of the DoCmd.OpenReport to force Access to save all records into the table tblSample, but it pops up an error saying, "the RunCommand action was cancelled". Do you know why is that?

Also, when I check tblSapme, the data ae there; the query (record source for tblSample), data is there, but when I open the report, the datata is not there.
pls help-thank you

 

[ttimkim]

The report to show all records

Thank you for your help. I would like to save all records to show on the report because that's the requirement. Also, I have a loop to assign values into tblSample as following:
Do Until rsG.EOF
rsSample.AddNew
rsSample.Fields(1) = rsS.Field(1)
rsSample.Fields(2) = rsS.Fields(2)
rsSample.Fields(3) = rsS.Fields(3)

rsSample.Update
rsS.MoveNext
Loop

I think rsSample.Update already do the saving job, but I don't know why the report does not show up the records.

I try the code DoCmd.RunCommand acCmdSaveRecord, but it does not show data either. Do you have any idea??? Thanks

 

[ttimkim]

requery

Hi,
Thank you for your time and effort. I guess I am able to solve the problem. I use requery and the report now shows the data.

Thank you again,
Tim

 

[jsanders]

It sounds like that report is staying open in the background.
Maybe you should do both, use

DoCmd.RunCommand acCmdSaveRecord
then requery the report.

 

[ttimkim]

--Quote--
DO NOT USE requery to force Access to save the current record. It has side effects you will not like. Why don't you want to use the command I suggested?
--Quote--

Like I said in the previous post, I use DoCmd.RunCommand acCmdSaveRecord but it does not work; the report does not show up the data .

 

[meilbeck]

Thanks

I was having a similar problem and Pat Hartman's suggestion of using "DoCmd.RunCommand acCmdSaveRecord" fixed it. I needed a quick solution and this was just the job so many thanks!