Add a coma following your existing OpenForm
DoCmd.OpenForm "FRMVehiclesInWorkshops",
The results are miraculous. Intellisense shows you all the other arguments for this method. You need to provide a value for the WHERE argument. That will make the form open to the record you are currently sitting on. AND PS for the person who asked, it is completely irrelevant whether you run this OpenForm command from a single or continuous form. Why? Because ONLY ONE record is ever current regardless of the form type and that is what you get when you refer to Me.somecontrolname.