Cant refer to combobox after message box

[andy49]

Procedure is as follows:

select option from combobox

cboPaper_onchange() kicks in and message user to say what to do next with a basic information message box.



But when I try to refer to a column in the combobox after that

me.cbopapers.column(2)

I get a null

Without the message box it works beautifully. But I need the messagebox

What's happened?

Debug.Print Me.cboPapers.Column(0)
MsgBox "please select the students who you wish to sit the " & Me.cboPapers.Column(1) & " paper and press the update button.", vbInformation
Me.SetFocus

rs!PaperID_FK = Me.cboPapers.Column(2)

[June7]

Don't need Me.SetFocus, although it doesn't seem to hurt in this case.

Can't replicate the issue. Code works for me. Would have to review your db.

[andy49]

DBschoolexamPapersvtest11.zip

As requested June

The form is FrmSelectTiers

[andy49]

A tough week - changed the bound column to a column beyond the 5 in the cbobox.