How to force the cursor to a particular field on a form SOLVED. Your are using MS ACCESS Where you want user need to enter data using form with some controls. Dont look into speed if you need user must enter details for required field. Or you can set those field default values Please if you look speed then loose content for other field where you also need user have to enter or set those field default. Option is what user says Performance never matter when user need but can be considered You can speed by setting a drop down menu for constant value if user is entering HAVE NICE DAY For performance go for higher database SQL products if need and in budget. Update Main Form From Subform Access' title='Update Main Form From Subform Access' />Microsoft Access Techniques Revision 922012 Page 2 of 119 Copyright 20012012 by Susan J. Dorey Protect Form Field From Update. Update Main Form From Subform Access' title='Update Main Form From Subform Access' />Form Design Articles from Database Solutions for Microsoft Access Here you will find articles and tips relating to Microsoft Access form designs, from adding. The SetFocus method moves the focus to the specified form, the specified control on the active form, or the specified field on the active datasheet. You. Im using Access 2010. Dell Optiplex 755 Firmware Update here. I have a main form with 4 tabs each holding a datasheet subform. When I first start up and click on each tab in turn, the first. Duplicate the record in form and subform. The example below shows how to duplicate the record in the main form, and also the related records in the subform.