Form Button Link To Listbox, Access 2000 & 2003

J

jfcby

Hello,

My select query looks like this:

Part Number Part Description Price $Numbers
AHU-A *ebook-A 2.99 2456-001
AHU-A *ebook-A 3 2456-002
AHU-A *ebook-A 3.01 2456-003
AHU-Q *ebook-Q 3.02 2456-004
AHU-Q *ebook-Q 3.03 2456-005
AHU-Q *ebook-Q 3.04 2456-006

Since I had multiple items in Part Number Field I created a Find
Duplicates.

Then I created a form put a list box on it using the Find Duplicates
Query.

Now I would like to know how to add a button so that when I make a
selection in my list box it will open the select query listing only
the information for that item.

Thank you for your help,
jfcby
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Right(), Access 2000 & 2003 2
Record output in queries 1
Export multiple Tbls from one Qry 5
Search by product & alsoshow other products purchased by same cust 2
Find a string in a column 1
Find a string in a column 4
Counting Column 3
form combo box question 4

Top