Hi all,
Very new to access so i apologise in advance if i ask stupid questions.
I am creating a database and have managed to create a form with a search bar that then populates a listbox below the search bar as a query searches the database table. What i would now like to do is allow the user to double click on any of the items returned in the search and a form would pop up containing even more information regarding the item they have clicked.
For example the database is for mould tools and as tool numbers are searched the only info shown in the listbox is customer, location etc. I would like to allow people to then double click the tool they require and see all of the other tool information stored in the table.
I can attach the database if that helps people.
Thanks in advance.
Jack
Very new to access so i apologise in advance if i ask stupid questions.
I am creating a database and have managed to create a form with a search bar that then populates a listbox below the search bar as a query searches the database table. What i would now like to do is allow the user to double click on any of the items returned in the search and a form would pop up containing even more information regarding the item they have clicked.
For example the database is for mould tools and as tool numbers are searched the only info shown in the listbox is customer, location etc. I would like to allow people to then double click the tool they require and see all of the other tool information stored in the table.
I can attach the database if that helps people.
Thanks in advance.
Jack