Search results

not in the report no. i just want the report to filter by the text in the combo box cbrCustomerVisit

Its code to open a report at filter the results by the value in the combobox

If Me.cbrCustomer & "" <> "" And IsNull(Me.cbrQuoteNumber) And IsNull(Me.cbrEngineer) And IsNull(Me.DateStart) And IsNull(Me.DateFinish) Then strFilter = "[CustomerVisit] = '" & Me!cbrCustomer & "'" DoCmd.Close DoCmd.OpenReport...

Sorry cant its too large. i want a combo box to show as the row source the information in the query??

Ive made a quote, but i can get it to use the query as the record source any ideas?? Thanks in advanced for the help

No i havent. I havent used querys, dont know how really

First of all just to say this is quite hard to explain but ill do my best :) What i have is a report that gets all of its fields from a table. In this table all of the information comes from their own seperate table. In which they are the primary key... Except one. The one is the problem...

Im looking for a solution to my current problem, i have a form which filters a report as a search function. The report gets its information from a table that another form writes too. The problem is one of the fields that the drop down boxes in the form is linked to a field in another table...

I have some code. I want it to filter the Total Hours Worked column by Null.(show only the fields that hae nothing in tat column) Here is my code ElseIf Me.chkIncompleted = True Then strFilter = "[Total Travel Time] = Is Null" Debug.Print strFilter...

nevermind False seems to cover both untrue states

oh btw can you do Me.chkIncompleted = NotTrue ????

ahh nevermind i know why thanks for the help :)

Hmm its still showing the ones where the total hours worked isnt Null

ahh nice one.... i think its working now but i still think i need to put the ors and and's

Neither are the case?

it gives syntax error still, and highlights that code, and when i take the code out the rest of the code runs fine

if it worked i wouldnt post it ;) and because otherwise it does hours worked and engineer1 Or Engineer 2 Or Engineer3

Please just tell me :D

I cant see whats wrong

ElseIf Me.chkIncompleted = True And Me.cbrEngineer & "" <> "" Then strFilter = "[Total Hours Worked] Is Null And " & _ "[Engineer 1] = '" & Me!cbrEngineer & "' OR " & _ "[Total Hours Worked] Is Null And " & _...