not seeing all of the quoteid for a given job#

B

babs

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
 
J

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?
 

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

Similar Threads

If then in an SQL clause - to filter drop down list 3
Pit may be null- getting can't have zero length string error 2
Posted before didn't get a response- populating dropdown 2 sources 5
Filter a drop down list based on what is selected in prev. list 4
msimatch error 13- someone posted a question as an answer - repost 10
Pulling data from values selected in dropdown list-values back to 1

Top