Dlookup

[Eranka]

Hi

 
myValue = InputBox("Please Enter Lecturer ID")
sql = DLookup("Lecturer_Name", "Lec_Details", Lecturer_ID = myValue)

i tried above dlookup function, but its not working. Appreciate your help on this matter.

[Bob Fitz]

Maybe:

myValue = InputBox("Please Enter Lecturer ID")
sql = DLookup("Lecturer_Name", "Lec_Details", "Lecturer_ID = myValue")

[ranman256]

myvalue must be outside the quotes to resolve, while field name is inside:

sql = DLookup("Lecturer_Name", "Lec_Details", "[Lecturer_ID] = " & myValue)

[Bob Fitz]

myvalue must be outside the quotes to resolve, while field name is inside:

sql = DLookup("Lecturer_Name", "Lec_Details", "[Lecturer_ID] = " & myValue)

That's what I thought but before posting I looked up the syntax at: https://www.techonthenet.com/access/...in/dlookup.php where it says:

Syntax

The syntax for the DLookup function varies depending on what datatype you are uisng in the last parameter. Below we show how to use the DLookup function with numeric, string, and date value in the final parameter.
Numeric

DLookup("FieldName" , "TableName" , "Criteria = n")

[isladogs]

That syntax only applies where a specific number value is specified. For example

sql = DLookup("Lecturer_Name", "Lec_Details", "Lecturer_ID = 5")

However as the input box value is being passed to a variable, myValue, this IS correct for a number field

myValue = InputBox("Please Enter Lecturer ID")
sql = DLookup("Lecturer_Name", "Lec_Details", "Lecturer_ID = " & myValue)

OR for a text field

sql = DLookup("Lecturer_Name", "Lec_Details", "Lecturer_ID = '" & myValue & "'")

[Bob Fitz]

That syntax only applies where a specific number value is specified. For example

sql = DLookup("Lecturer_Name", "Lec_Details", "Lecturer_ID = 5")

Thanks Colin. At least I'm no longer confused although I am rather surprised that TechOnTheNet don't show the correct solution for this scenario which I would think is the most common.

[isladogs]

Hi Bob
I agree totally. Had assumed there was a follow-up page to include the use of variables but that seems not to be the case

As is so often the case, Allen Browne does it better: http://allenbrowne.com/casu-07.html