Keep on current record when I press the edit button

[ConnorLally]

I have this form set up so that when you double click on any of the records in the "EquipmentID" fields, it opens up another form which has a button to allow you to edit that particular record. However, when I press the edit button on the new form, it goes to the first record regardless of what record is selected. Is there a way to keep on the record I have chosen when I click the button to prevent me from having to step through the records to find the one I want to edit?



My database is enclosed in zip format for anyone to have a look at and help.

Thanks in advance

ITAssetDB - New Search Function.zip

[ranman256]

open the new form filtering on the current record

docmd.openform "frmEdit1Rec",,,"[empID]=" & txtEmpId

[ConnorLally]

The form opens on the current record, but I have an edit button on that form which allows me to edit the record. when I click that button it goes to the first record and I have to step through all of the records to find the one I want again

[June7]

Why do you need an Edit button? The form opens editable.

You are use embedded macros and VBA - why not just VBA?

[ConnorLally]

The form does not open editable when I use the database.

And I am not very experienced at using VBA, I have never really had to use VBA at all so it is all new to me, hence why I tend to gravitate towards macros

[June7]

I double click on the EquipmentID field and CopyOfEquipmentDetails opens. I edit fields on main and subform. Did not click Edit button. Why is there an Edit button?

[ConnorLally]

Ah, I have just realised that I changed the way in which information is viewed in my database.
My apologies, that form used to be how I viewed the information and also edit it. but I have a different form to view information on a record now. I will keep that form as always simply an edit form and remove the button.
My apologies for taking up your time with something I should have realised whilst doing it.
Thanks for helping bring this to my attention