Dlast with multiple criteria

[sdel_nevo]

HI Guys



im really strugling with the following code,


Me.SOITEXTBOX = Nz(DLast("SOITextBox", "SOIDetails", "Partnumber='" & Forms!SOISWUAddDetails!PARTNUMBERTXTBOX & "'" & "And Uni = True" & "And Location='" & Forms!SOISWUDashBoard!EmployeeDepartmentTXTBox & "'"), 0)

when this is run on i get

Error 3075(Syntax error(Missing operator) in query Expression

any help would be great as im getting lost now

many thanks

[Bob Fitz]

What is the data type of Partnumber

[orange]

Many developers do not use DFirst or DLast. Can you use DMin or DMax on some field?
You could add some spaces before Ands since your expression runs together.

"'" & "And Uni = True" & "And Location='"

Is SOITextBox really the name of a field in your table?

[sdel_nevo]

HI Bob

Part Number and Location are both text data types
uni is a yes no box

Kind Regards

Steve

[sdel_nevo]

Hi Orange

Yes SOITextBox is a name of a feild in the table SOIDetails

Knid regards
Steve

[sdel_nevo]

Hi All

well after pulling out most of my hair i have removed the & "And Uni = True" part of the code and the code runs as i require, i will remove this part of the code as "Uni" appears to be always true when the form opens and there is no code that sets this to false

i love access but its really hard taking over someone elses system when their is no documentaion

don't you justlove 5 minute jobs

anyway many thanks to both for all your help

Steve