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?
Code:
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
Code:
rs!PaperID_FK = Me.cboPapers.Column(2)