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

Top