not seeing all of the quoteid for a given job#

[Guest]

I have put in the following code to filter a quoteid drop down list based on
the job # selected in the previous dropdown. There may be 5 quotes for
example for one job# with the below code I am only seeing 1- the first quote
for a given job#. would like to be able to see all quotes in the dropdown
that are from the same job#.

What am I missing here.


Private Sub cbojob_AfterUpdate()

Dim aSQL As String
aSQL = "SELECT Quoteid, job,Clientid,cost,overallmarkup,pit,
markup,taxrate,origin,destination,divisor,grossweight,taxex,cartagerate,fuelperrate,commentf,material
" & " FROM tblquotejoe " & "WHERE job= """ & Me.cbojob & """ " & "AND
accepted = yes ORDER BY QUOTEID"
Me.cbquoteid.RowSource = aSQL

[Taxex] = Me.cbojob.Column(1)
End Sub

Thanks,
Barb

 

[Guest]

Sorry I figured it out.

 

[jleckrone]

You could have multiple quotes for one job, but are they all accepted?
Could that be why you are not seeing all the quotes?