troubleshooting Question

MS Access 2010 - is it possible to create a button next to a lookup field that jumps to the record of what its looking up

Avatar of mrroonie
mrroonieFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
14 Comments1 Solution504 ViewsLast Modified:
hello all

i'm trying to teach myself access to build an asset register for the office - the templates i have found to download all look like they need a massive amount of editing to be how i want them. i have a 1000(!) page reference book on it and it is serving me well but theres one thing i want to do that i can't find in the book, so i'm wondering if its possible or not:

in my database, among other tables that have no relevance, i have an equipment table and an asset number table. there is a field in the equipment table that links to the asset number table - i created the link by using the 'lookup wizard'. this is fine and works well, but i also have a field for entering associations, for example my PC is asset number 0001 and the monitor (an 'associate' of the PC) is asset number 0002 - for the associations field i have used the lookup wizard again that looks up the asset number.

on the equipment form i have fields for serial numbers etc. what i want is a button next to the associations on the equipment form, so if i'm on the record of asset number 0001, when its clicked it autmatically takes me to the asset number 0002 record

is this possible? if so, how can it be done?

thanks in advance for suggestions
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 14 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros