I am new to access and have been trying to solve this problem for days, and can't seem to dig up anything online. Any help will be appreciated!
I am making a database to rent out equipment at my company. You can find my current version here if interested:https://1drv.ms/f/s!AkwyiifpjisUgdQseWttuH-E6yYPDw
My problem:
I would like to edit records using a form. I know this is possible when you have a table inside the form displaying all of the records available, and you just choose which one. However, the problem with this, is that my users don't know what item to pick in a table, they want to choose an image (picture of bike, not description of bike).
What I have been trying to do is:
I have a table with records for bikes, and I have a form that is used to view the bike information along with the images. I have a button beside each bike that says "check out". I have managed to get this to work. The problem comes with "check in". I can't seem to figure out how to get the button macro to ensure I am editing the correct record.
Any ideas??
Thanks in advance!!
Matt