make selections from a members list table and place it in form/rep

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have 133 club members in a table called members list and i want to use a
form to select certain members an place them in a separate form or report
 
Dennis,
Please explain in more detail why you want to select certain members. For example, do
you only want to see Active members, and not Inactive members?
Or, do you want to select a certain members one time, and other groups of members
another... perhaps for reporting upon?

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
tks i want to select certain members some weeks and others at different times
and keep a report on their activities for all members to read tks dennis
 
dennis,
Then I'll assume there is not always a "logical" method (like a department, or
classroom, or group) to figure out which ones you want to select for the report. Random
in other words...
A method I've used is to create a check field (T/F) field in that table, called
PrintMe. I run a dialog form (a mini-continous) just before running the report where I
can check all the records I want to report on, and use that as a criteria for the report.
I also add a PrintAll button to the dialog form to upadte each record PrintMe to True
when the user needs to print them all. Also a Clear button to False all the records when
starting a new selection/s.
Is that what you wanted?
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Back
Top