W
WCDoan
I don't know if that subject matter was the right description for what I'm
trying to do, so here it is in more detail. I have button on a form that
opens another form. There is a button on the second form to print the records
of the second form. The report looks like this:
Family Members
Name Relationship
xxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx
bbbbbbbbbbbbbbbbbbbbb bbbbbbbbbbbbbbb
cccccccccccccccccccccccc ccccccccccccccccc
I need to print the name and relationship of each record that matches the
key on a separate line. Right now, the way the report is set up, it prints
the same record 4 times then prints the next record 4 times and so on for
every record that matches. I'm getting the right data just not printed the
right way. I'm not sure how to do this. Could I do it with a For Next Loop or
something like that? And how would I address each print area (name -
relationship) on the report? As many of you know from helping me with
previous questions I have had, I'm a newbie, close to wit's end, and
continuing to be run over by trains that I think are the lights at the end of
the Access tunnel.
Again, I won't to thank all of you who have helped me
out in the past and thank you for your patience with me and with my learning
curve which is much bigger than I anticipated. I took a class and the teacher
said a lot of times programmers from Cobol and other languages have a hard
time adjusting to Access because of the event driven nature of it and the
programmer being use to more of a beginning to end type of logic flow. Plus,
she said we sometimes make things harder than they are because a lot is
already built into Access. I think she's right on both accounts, but it's
just getting to the point where the light finally comes on. Thanks again for
all your help.
Randy M
trying to do, so here it is in more detail. I have button on a form that
opens another form. There is a button on the second form to print the records
of the second form. The report looks like this:
Family Members
Name Relationship
xxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx
bbbbbbbbbbbbbbbbbbbbb bbbbbbbbbbbbbbb
cccccccccccccccccccccccc ccccccccccccccccc
I need to print the name and relationship of each record that matches the
key on a separate line. Right now, the way the report is set up, it prints
the same record 4 times then prints the next record 4 times and so on for
every record that matches. I'm getting the right data just not printed the
right way. I'm not sure how to do this. Could I do it with a For Next Loop or
something like that? And how would I address each print area (name -
relationship) on the report? As many of you know from helping me with
previous questions I have had, I'm a newbie, close to wit's end, and
continuing to be run over by trains that I think are the lights at the end of
the Access tunnel.
Again, I won't to thank all of you who have helped meout in the past and thank you for your patience with me and with my learning
curve which is much bigger than I anticipated. I took a class and the teacher
said a lot of times programmers from Cobol and other languages have a hard
time adjusting to Access because of the event driven nature of it and the
programmer being use to more of a beginning to end type of logic flow. Plus,
she said we sometimes make things harder than they are because a lot is
already built into Access. I think she's right on both accounts, but it's
just getting to the point where the light finally comes on. Thanks again for
all your help.
Randy M