Could I please get a little help creating a command button?
I know how to create a command button that adds a new record to a form. But I need a command button that will add a new record to a form, and then set the tab focus to a specific field. I'm not sure how to do that.
I found some VB code through a Google search: Forms!Employees!EmployeeID.SetFocus
I modified it to work with a command button: Forms!frmGenre!MainGenre.SetFocus
And this worked. But I am not yet sure how to write code to add a new record. Is it possible to create a command button using the Command Button Wizard, that will let me add a new record to the form, and then also plug in this VB code? If that's possible, I'm not 100% sure how to do that. I'm basically a novice and haven't dabbled all that much with macros or VB yet. But I am ready and willing to learn.
Thanks! Warren Page