automated method of editing records using forms

[matt_wpg]

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

[ranman256]

normally, youd have a list (continuous form) of records,
The user selects a record in the list, click a button to open the 'detail' form, that shows only the 1 record.
This opens that given record by using the recordID,

docmd.openform "frmDetail", , ,"[id]=" & me.txtID

then put a button on this form to 'check in'.
again use the recordID to checkin.

[matt_wpg]

Ahh ranman256 you are a genius! That worked! The key was ensuring the macro was also opening the checkin form in "edit mode" as well.

Thanks for the help, much appreciated.