Print records from a form ....

[DanAtCDS]

Maybe I'm over thinking this, ... BUT
I have a very basic form that accepts a date, Client, Count and Type. What I need to do is print a report (Header tag for a group of documetns) after every three entries on this form. i.e., End user enters:
Date Client Count Type
11/8/04 ABC 10 1
11/8/04 EFG 15 1
11/8/04 XYZ 20 2

And then I want Access to produce a one page report of header tags (1/3 page for each record) for the information just entered. While the form is still open and the end user is still entering data.

Can this be done??
I've hit a mental road block so any help will be much appreciated!!
Thanks,
Dan

 

[dhookom]

How do you identify the "information just entered"? Are you storing some value that can be used to determine this?

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[misscrf]

what about every 3rd record? Only problem is that it would take a lot to define that.

You would have to say if 3,6,9,12, as far as you think it will go, print, else no print, and then what to print.

Yep thats how good I am at code lol


misscrf

Management is doing things right, leadership is doing the right things

 

[DanAtCDS]

dhookom,
I guess that is part of my question as well. How is it best to identify to Access that the 3 records the end user just entered are the records I need to print. I can add a field to my table in order to "tag" the records but I'm not sure where this will get me either?? The "info just entered" would always be the previous three records.
Enter record one [tab to the next]
enter record two [tab to the next]
enter record three [tab to the next AND print previous three].
I need the printing portion to happen once the 3rd record was committed to the table. (but, then, what if there weren't three records entered this particular time?!?!)
Thanks in advance for any help you can give me!
Dan

 

[dhookom]

I think that you need to set some specifications. At minimum, there should be a field that identifies the order records were entered such as an Autonumber or date field that defaults to Now().

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]