Only show certain records in main form.

  • Thread starter Thread starter Flopbot
  • Start date Start date
F

Flopbot

I haven’t been able to find anything directly addressing this type of
situation in other posts. Any help would be greatly appreciated! Thanks in
advance! I have a main “Volunteer Database Form†that’s drawing its
information from a “Volunteer Info Tableâ€. Attached to this main form is a
“Volunteer Interests Subform†(it comes from a “Volunteer Interests Tableâ€)
which has 5 different fields with check boxes in them: [Admissions / Gift
Store], [Education], [Exhibits], [Office / Technology], and [Special Skills]
(Each is in yes/no format). On my main form I want to place 5 command
buttons; one for each field. When I press the button, I would like the form
to automatically limit the number of records it presents to only those
records that have a check in the checkbox (?in “Volunteer Interests Subformâ€
or “Volunteer Interests Table�). I want all the other records to be hidden.
All of my tables are linked via [Volunteer ID]. Is this possible? Any
ideas? Unfortunately, I don’t know anything about code. Sorry!
 
there is more than one way to do this.

one easy way is to create a duplicate form but that is sourced on a query ;
and this query has the filtering parameter of the volunteer interest type
selected....call this Form2 and Query2

in your existing Form you need an unbound textbox (Vbox) and whether you use
buttons or checkboxes or whatever - however selected you need to write the
correct volunteer interest type word into Vbox

Query2 have its filtering parameter Forms!YourForm.Vbox

When you launch Form2 it will show only the data from Query2
 
Back
Top