Clickable items from table

Michael Noze
Michael Noze used Ask the Experts™
on
Hi Experts,

I have a table with data in which I'd like to have a "Clickable" list of Equipements.
When an equipment is selected, it'll populate all the information related to that specific equipment to a form.
IE:
I'd like
E1
E2
E3
...
E16
to be in a selectable rectangle and when an equipment is clicked, it selects the form Inspections and it fills all data related to it.
Is there a way to do it without drop box/list ?
Planning.accdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software & Systems Engineer
Commented:
How about a continuous form for the clickable item and the "data" to another subform.
Tables do not have events, so nothing to kick off the code.
If you create a form based on your table (I would suggest a datasheet form or a continous form), then you can create a click event for the textbox with your equipment ID,and the click event can then open the form of your choice, filtered to the record.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial