Last field in last record not in report...

  • Thread starter Thread starter Dr. Roberto VALENTE
  • Start date Start date
D

Dr. Roberto VALENTE

Hi all,

I am building a simple test program in Access 2000. It will take 10
questions out of a database of hunfdreds and present them to users...
Everything works, except this:

If you answer the last question (which could be any question in the
continuos form) and press "Print Test Results", the last answer will
not be considered, it will stay blank...

If I move to Prev/Next record, before printing, everything works
fine...

What I am looking for is some code in the print button do to it for
me... tried move next, move prev... they don't work :-(

Thanks for any help you may provide...

Ciao, Lupo
 
Hi all,

I am building a simple test program in Access 2000. It will take 10
questions out of a database of hunfdreds and present them to users...
Everything works, except this:

If you answer the last question (which could be any question in the
continuos form) and press "Print Test Results", the last answer will
not be considered, it will stay blank...

If I move to Prev/Next record, before printing, everything works
fine...

What I am looking for is some code in the print button do to it for
me... tried move next, move prev... they don't work :-(

Thanks for any help you may provide...

Ciao, Lupo
Click to expand...

Access does not save the record until you close the form, move to the
next record, close the database, or you expressly tell it to.

Code the command button click event used to open the report:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName", etc
 
Dear Fred,

that works, almost... in the sense that it does update my answer
count, but the form takes a second (less, actually) to do it and when
I check if the number of answers corresponds to the number of
questions, it's still one behind...

Basically, I only need a code between your two lines to "waste time"
before executing the second one and I'll be all set...

Does such a command exist?

Thanks again, Lupo
 
Back
Top