Drop down box help

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

Guest

I love this news group. I have learned so much through all of you. Thank you!

The database I am currently working on I have a form that lists general
types of issues that clients may be experiencing (eg. Web problems, customer
service, other, etc) What I would like to happen is that when one type of
Issue such as Web problems is chosen, all of the records that are reporting
to have web issues will be displayed but no others. How can i make this
happen?
 
Hi Mimi

There are many ways to do what you want.

You could have a form and subform - the main form would simply have a combo
with a record source set as the field that contains all the different types
of problems. The subform would be filled with the details you're after -
ensure you include the "problems" field in both forms. In the after update
you could requery the subform so that it only contains the records with
matching "problems"

Or

You could use Query By Form that could be answered by a bound dropdown on a
pop-up. After update the form (based on your QBF) would open with the
details.

Etc, Etc

Press F1 and search on Child/Parent Forms and also on Query By Form or look
at the main MS website knowledgebase

I don't know the specifics of your data base but looking at your post I
wouls prob use QBF but have a number of criteria boxes on your pop-up. That
way you can restrict your results more so that you get the records you want
and not too long a list.
 
Back
Top