Search results

Thankyou for your prompt reply. Yes the table field is a number - defined as long integer unfortunately Me.CoursePrice = DLookup("[CoursePrice]", "[tblintschedcourse]", "[InternalScheduledCourseID] = " & Forms![frmaddintbooking].[CourseTitle]) produced the same 2465 error

Help please. I am using Access 2016 as part of Office 365 with a database in the accdb file format of 2007-2016. On one form I can get dlookup to work but another I cannot. I know it is something to do with the variable types and the corresponding syntax i'm using, but I just cant find a...