By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,928 Members | 1,580 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,928 IT Pros & Developers. It's quick & easy.

Creating a Clickable list

loonette
P: 17
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
Apr 5 '10 #1

Share this Question
Share on Google+
5 Replies


topher23
Expert 100+
P: 234
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

Expand|Select|Wrap|Line Numbers
  1. SELECT ID, BidderName FROM tblBidderInfo ORDER BY BidderName;
  2.  
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:
Expand|Select|Wrap|Line Numbers
  1.     DoCmd.OpenForm "frmBidderInfoNum", , , "ID = " & Me!lstSelectBidder
  2.  
and that ought to do it. Let me know how it works for you.
Apr 6 '10 #2

loonette
P: 17
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
Apr 9 '10 #3

loonette
P: 17
Thank you so much for your help. I worked on the code using the form filter and it works! I am so grateful!
Apr 10 '10 #5

NeoPa
Expert Mod 15k+
P: 31,769
I'm very pleased I could help Lori :)

Welcome to Bytes!
Apr 12 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.