How do I create several option buttons for a report?

[NotAProgrammer]

Hello,
Recently I attempted to write a database to call up defects over period of
time. I need help!
Question1: Let's say I have 5 defects listed in the same column in the
table and I only want to see the data for 2 of the defects. How can I create
option buttons to pick 2 defects, press "display record" button and have
only these 2 defects data display?

Question 2: Instead of having 5 option buttons on the form, how can I make a
droplist that I can pick any 2 or multiple combination and have those record
display?

 

[Duane Hookom]

You would want to use a list box that allows multiple selection. There have
been many threads on how to use a multi-select list box as the criteria for
a query. One solution with sample usage is at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[NotAProgrammer]

Duane,

Thank you for the advice. Your program allows for calling up the data in a
form display. How can I change it to calling up data to display a record?
Thank you.

 

[Duane Hookom]

I don't understand what you are asking. Can you provide some sample records
and how you want to query them?

 

[John Vinson]

Thank you for the advice. Your program allows for calling up the data in a
form display. How can I change it to calling up data to display a record?
Thank you.

Ummm...

the best way to call up data to display a record IS to call it up in a
form display. That's what forms are *for*!


John W. Vinson[MVP]

 

[NotAProgrammer]

Duane,

Thank you for being patient with me. I have a table with multiple suppliers
experiencing multiple defects over a period of time. I want to go to a form
and have the option of picking the suppliers, defects and or date. This will
open up a printable report showing every row of data having the requested
combination.

Again, thanks for the help. I really appreciate your helps.

 

[Duane Hookom]

The records displayed on the form come from a query. The same query could be
the record source of a report.