Cascading Combo Box-Can only select once

S

Scuda

Hi all. I have a combo box that when selected fills in (4) text boxes. It is
working fine, however after I select my first drop down I cannot select
another! Here is the code I have in my After Update event of my Combo Box:
(it's called lkupquestion)

Private Sub lkupquestion_AfterUpdate()
On Error GoTo ProcError

Me.answer = Me.lkupquestion.Column(2)
Me.link1 = Me.lkupquestion.Column(3)
Me.link2 = Me.lkupquestion.Column(4)
Me.link3 = Me.lkupquestion.Column(5)

ExitProc:
Exit Sub
ProcError:
MsgBox "Error " & Err.Number & ": " & Err.Description, _
vbCritical, "Error in procedure lkupquestion_AfterUpdate..."
Resume ExitProc
End Sub

any help GREATLY appreciated!
Steph
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top