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

Tips on how to utilize search options

P: 17
Hey guys me again :)
MS Access 2010

Please look at the attached picture to visual what I'm trying to say. Also, this is all one question but with multiple parts as they all tie in together.

I have made a a query in a list box to show all of the information relevant to the table (Equipment List). I have also created a search function so that the user can type in what he is looking for and it will be displayed.

Now what I want to know is how to:

1. When a user clicks/double clicks on one of the fields in the List box/search box, how can I get all of the information associated to that item to display in the fields above it. I can't work out any code for that and cannot find anything specific on the net. I want the information for the item that comes up to be editable ie. the user can alter the information

- I have tried using something along the lines of:
=[SearchResults].[column](5)

This however only displays exactly what is from that column, whereas I have close to 30 columns and I think I can only use 16 in my query? Additionally, using this method I wasn't able to edit the information.

1.1. In my ListBox, the headings/field names aren't showing above the fields. For example, there should be the word "Description" above chemical injection and heat exchanger

1.2. Lastly, is it possible to create a similar search function in this listbox that is similar to that of excel? Eg, so I can select a column in the listbox and search only characters specific to that column?

Thanks guys been lots of help lately
Attached Images
File Type: jpg equipment list form.jpg (54.3 KB, 101 views)
Feb 11 '15 #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,486
I think you would be better off to have the user enter data into the fields on your form and filter a subform with all your equipment items based on the entered data. Then the user will have a list of all equipment that meets the criteria specified.
Feb 19 '15 #2

Post your reply

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