If a private sub from within a Form calls a Public sub are any of the variables in the Public sub available in the private sub ?
For example if I call Public Sub Volunteers and the Public Sub has a variable called strVolunteerName Name will strVolunteerName be available in the Private Sub if strVolunteerName has also been declared in the Private Sub ?
If no how can strVolunteerName be made available to the private sub.
The goal is from the Form sub to call the public sub several times so I can retrieve Volunteer information. Currently I have a record-set retrieval for volunteer information being done from within in the private sub, but the same recordset retrieval is repeated within the private sub several times so I believe this is a good instance where the retrieval should be placed in its own sub, but I always get confused on the public/private declaration.