Take the cursor to required field after adding a new record on clicking button

Question

I created a button in my form. Using macro expression builder, it is programmed to add a new record on event click. Until this step, all went fine and have done successfully. But after creating the new record, I want the highlight to take me to the first field (in which information is required to be added to)

To be more elaborate, the particular field is present in the form header and not in the detail section. So, I tried "tab reorder", in futile( it did not have an option). To summarise, want the field on the header to be highlighted by clicking the button (of course after adding a new record)

Any suggestion on this?

Answer 1

Edit the macro.Add a GoToControl action at the end, and enter the name of the control in the form header that you want to set focus to.

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)