I have the following code in the after update in my combo box. It's now
producing any any informaton in my text box

Private Sub cboAMUProcess_AfterUpdate()
Me.Question1 = DLookup("[Questions]", "[tblAMUQuestions]",
"[Process]='" & Me.cboAMUProcess & "'")

End Sub

Can someone please advise what I am doing wrong?

Welthey wrote:
> I have the following code in the after update in my combo box. It's
> now producing any any informaton in my text box
>
> Private Sub cboAMUProcess_AfterUpdate()
> Me.Question1 = DLookup("[Questions]", "[tblAMUQuestions]",
> "[Process]='" & Me.cboAMUProcess & "'")
>
> End Sub
>
> Can someone please advise what I am doing wrong?

Many ComboBoxes contain one value in a hidden column while displaying another.
If yours is like that then you are referring to the hidden value which might not
be the correct one for your DLookup function.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Welthey,
Since your not getting a "syntax" problem, we should be able to set that aside.
I usually don't use the Me. object within DLookups
Me.Question1 = DLookup("[Questions]", "[tblAMUQuestions]", "[Process] = '" & cboAMUProcess
& "'")

The primary thing to suspect is that the cbo is not delivering a legitimate value for
[Question]
Try this trick to verify the contents of your cbo. Place an unbound text control on
the form with a ControlSource of...
= cboAMUProcess
Is that a legitimate (and unique) [Question] value?
Otherwise...
Please describe your cbo (bound vs unbound), RowSource/columns, and your cbo
properties. (NoOfCols, Columnwidths, and BoundColumn)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."


"Welthey" <(E-Mail Removed)> wrote in message
news:01AE22B5-435D-4849-9366-(E-Mail Removed)...
>I have the following code in the after update in my combo box. It's now
> producing any any informaton in my text box
>
> Private Sub cboAMUProcess_AfterUpdate()
> Me.Question1 = DLookup("[Questions]", "[tblAMUQuestions]",
> "[Process]='" & Me.cboAMUProcess & "'")
>
> End Sub
>
> Can someone please advise what I am doing wrong?

Welthey wrote:
> I tried your idea and I am getting the ID number in the unbound text
> box. How do I set up the combo box to read the 2 column not the first?


Me.Question1 = DLookup("[Questions]", "[tblAMUQuestions]", "[Process] = '" &
Me.cboAMUProcess.Column(1) & "'")

The columns start with zero so Column(1) is the second column.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com