Basic ?

  • Thread starter Thread starter clu
  • Start date Start date
C

clu

When data is deleted from fields in a record in the Access '03 database that
I am using, the report continues to reflect that information. How can I
remove that information from the report as well? Thx
 
clu,
save the data in the form before you open the report.
If you have a button that opens the report, code it to do

If Me.Dirty = True Then
Me.Dirty = False
End If
DoCmd.OpenReport 'etc etc


Jeanette Cunningham -- Melbourne Victoria Australia
 
ps

I meant to requery the form before you open the report - instead of the code
I posted in the previous post.
The requery makes the form go back and get its recordsource.
When it does this, it doesn't get the records that have been deleted and
they don't show in the form after the requery.

Me.Requery
DoCmd.OpenReport 'etc etc


Jeanette Cunningham -- Melbourne Victoria Australia
 
You must log in or register to reply here.

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

how do I attach a value to a check box in access 2007? 4
Viewing Data in Report 2
Link queries or forms/labels to a data base 2
Access 2003 - Report Problems 2
Access Access Report Works on One Machine but not Another 3
Can't create a report from my query in Access 1
Pass infomration from a form to a report... 1
How can I link tables with a form? (2007) 0

Back
Top