Item list seperator or)

[shutzy]

i am getting an error with a DLookup()

if Dlookup("[ItemsRemaining]",[qryClientCourseItemsRemaining], "ItemsID = &" [Forms]![frmDeparturesPaymentScreen-ItemListSubForm]![ItemsID])

it says
compile error
Expected: Item list seperator or )

i have tried to write this from scratch but still cannot manage it

any help once again

 

[Brianwarnock]

I think the &" are the wrong way round

Brian

 

[delikedi]

Try
if Dlookup("[ItemsRemaining]",[qryClientCourseItemsRemaining], "ItemsID = " & [Forms]![frmDeparturesPaymentScreen-ItemListSubForm]![ItemsID])

 

[shutzy]

thanks you two. i did try. at least i got all the correct seperators in there. ill will get ther you know.

thanks again

 

[Brianwarnock]

It may still need more tweaking dependent upon the contents of the control, read this

http://support.microsoft.com/kb/208786

Brian