Hello fellow users:
I used to write code using higher level languages. I just recently started to familiarize myself with Access2010. Here is what I am trying to do:
I have a preprinted form:
My thought process is this:
Get a client (record one from the query that has a unique field)
create a subroutine to print the top third of the page for client1
Print items on the middle portion of the page
If items are greater than 5, then do a subroutine that prints the bottom third of the page and jump to a new page
Call the first third routine again for the first third of the page to be printed
Continue printing the rest of the items (as long as it does not exceed 5 lines, otherwise, print a third page and repeat)
Do subroutine to print bottom third of page
Get the next client# and start the process again until the end.
Can this be done? And please, tell me how? In other words, can I open a query and read a record at a time and do the above until a new client?
I understand programming concepts I just do not know Access well. I'm a newbie.