Multi Valued Fields

[Poppy]

Does anyone know what vba code I need to use in order to move focus from a combo box to another control? The usual .setfocus method isnt working because the combo box is bound to a Multi Valued field. I receive the RunTime Error 2110. The control I am trying to move to is just a simple text box that is enabled and is visible so it has nothing to do with the text box control and is definitely the MVF combo box.

[Bob Fitz]

Can you show us the code that produces the error or better still, post a copy of your db

[June7]

I don't use MVFs but just did test. Get the same issue with AfterUpdate event. What other events have you tried?

[isladogs]

I also don't use MVFs and also did a test to move the focus back to the previous control

This does cause error 2110 as stated

Private Sub MVF_AfterUpdate()    
Me.ID.SetFocus
End Sub

but this runs without error & worked for me

Private Sub MVF_LostFocus()
Me.ID.SetFocus
End Sub

I clicked Enter to move the focus away from the MVF

Even so, another good reason for avoiding MVFs - see this article on my website http://www.mendipdatasystems.co.uk/m...lds/4594468763

[Poppy]

Can you show us the code that produces the error or better still, post a copy of your db

Hi Bob

Attached is a very simple example of what I am trying to achieve (sorry couldnt send my entire db but this one still demonstrates the issue).

Open the database and then on the form which opens just click on the drop down and select one (or more) of the options by ticking the boxes and then click OK. The code behind the after update event simply moves the focus to the next control using the .setfocus method but when doing this it produces the 2110 error.

Hope you can help

thanks
Poppy
MulitValuedCombo.zip

[June7]

I say let user learn to press Enter or Tab to move to next control, same as with other controls.

[isladogs]

Poppy
Have you tried my suggestion in post 4? Works for me

[June7]

That code requires pressing Enter key or clicking elsewhere for combobox to lose focus. Pressing enter will just take user to the next control without any code, which appears to be what the OP wants to accomplish - move to next control.

[isladogs]

The way the original question was worded indicated the OP wanted to move to a specific control rather than the next one in the tab order.
That was my reason for suggesting that solution.

[Poppy]

Just to clarify a little.
After selecting the options in the MFV combo box and then clicking on OK triggers the after update event which is what I want. Part of the code of that after update event is to move the control to a specific control. This is defined by what the user has selected and therefore maybe different each time. So I dont want the user to go to the 'Next' control but a specific one. I have some conditions in my code which work but its the .setfocus that doesnt. I am sure it has something to do with the OK button having the focus and not being able to move focus from it.

Thanks everyone for their input, I really appreciate it. I understand about not using MVF but this is an inherited db which I am developing and dont have loads of time to redesign it.

[isladogs]

So as I suggested, I think you will need to move your code to the lost focus event.
I suppose you could use SendKeys to click Enter automatically in the after update event but I wouldn't recommend that.