Search results

Finally found a workaround for this! Before making the detail section visible I've first moved the focus to a contol in the form header. Me.Combo120.SetFocus 'control in form header Me.Detail.Visible = True DoCmd.GoToRecord , , acNewRec Me.surname.SetFocus

Unfortunately that didn't work :-( I'm beginning to think it's a bug in Access ...

I've added a message box to the end of the code to check which control actually does have the focus - MsgBox(Me.ActiveControl.Name) - and this returns surname. So surname is the active control but for some reason the cursor isn't visible?

Changing the tab order makes no difference. If I do SetFocus first I get the error "Microsoft Office Access can't move the focus to the control name surname"

Thanks for the reply. I've tried that but unfortunately it hasn't solved the problem.... After setting Me.Detail.Visible = True it then goes to the new record but for some reason won't SetFocus.

(Access 2007) I have a form with some controls in the header. By default the form detail is hidden. I have the following code on a button Private Sub newclient_Click() Me.Detail.Visible = True DoCmd.GoToRecord , , acNewRec Me.surname.SetFocus End SubThe problem is that the focus isn't moving...

The new multivalue field type in A2007 does exactly what I want on a form, but I'm really against using multivalue fields and prefer to handle my many to many relationships with an extra table. What I want to do is somehow mimic the multivalue popup which allows multiple selection using check...