Creating a Clickable list

[loonette]

I'm sure that this has been asked on here, but I have been looking for the last hour and couldn't find anything that quite answers my question. I need help with Access 2000 and creating a clickable list. I have a table that lists all of our customers called "tblbidderinfo". I would like to create a new form that allows you to search by last name and when you click on the person's last name in a list it would pull up their record in the form "frmbidderinfonum". I'm sure that whoever helps me with this will need more information, but I am pretty green at this and don't know what other information would be required.

Thanks for any help you can give me!

Lori

[topher23]

Since I don't know the names of your fields, I'm going to assume a Unique ID for each customer called ID and a name field called BidderName.

Create a list box called lstSelectBidder, and set the RowSource to

SELECT ID, BidderName FROM tblBidderInfo ORDER BY BidderName;
 

In the list box Properties, set the number of columns to 2 but set the column widths to 0";2" - this will make it so the name shows up rather than the ID.

Now, go to the On Click event of the list box and click the builder (...). In the code for the event put this code:

    DoCmd.OpenForm "frmBidderInfoNum", , , "ID = " & Me!lstSelectBidder
 

and that ought to do it. Let me know how it works for you.

[loonette]

Topher,

Thank you for the reply, but I didn't make myself 100% clear. I would like to have a text box at the top of the form in which I could type a last name, for example "smith" and the form would then populate with all the customers whose last name is Smith and each name is hyperlink to it's record in my form "frmbidderinfonum". I have the name fields in "frmbidderinfornum" split between first and last with the fields being titled "firstname" and "lastname". I guess I want it to be like when when you search for something on eBay, like you put in "widgit" and a hyperlinked list of everything widgit being sold on eBay comes up. Is this possible? and if so how do I got about it? Please let me know if you need any other information about tables, forms or fields.

Thank you!

Lori

[NeoPa]

Check out :
Example Filtering on a Form.
How to Programmatically Create a Hyperlink on a Form.

[loonette]

Thank you so much for your help. I worked on the code using the form filter and it works! I am so grateful!

[NeoPa]

I'm very pleased I could help Lori :)

Welcome to Bytes!